By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

Command button to start new record in specific form

emandel
P: 65
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.

Here is my question:
How do I get a command button (on form 'a') to not only open a specific form (form 'b') (which I can do with the wizard) but to open that new form to a blank new entry?
Jan 1 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.

Here is my question:
How do I get a command button (on form 'a') to not only open a specific form (form 'b') (which I can do with the wizard) but to open that new form to a blank new entry?
In the properties of form 'b' you can set the Data Entry Property to yes if you only ever use that form to enter new records.

Otherwise, you can change the form open code as follows:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "form 'b' name", acNormal, , , acFormAdd
  2.  
Mary
Jan 1 '07 #2

emandel
P: 65
Thank you that was helpful
Jan 1 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you that was helpful
You're welcome.

Happy New Year!

Mary
Jan 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.