468,539 Members | 1,586 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

Command button to start new record in specific form

emandel
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
3 6903
MMcCarthy
14,534 Expert Mod 8TB
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
65
Thank you that was helpful
Jan 1 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
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.

Similar topics

reply views Thread by jpr | last post: by
7 posts views Thread by pukhton | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.