Command Buttons

[Guest]

Hello There

I am trying to create my startup page but I am having trouble with the
command buttons.
I want to create a button that will add a new record to my database. When
the users presses the button I want it to take them to my main form to enter
the information but when i use the wizard it doesnt seem to connect the two
forms. I know I am missing code but I don't know what to write. Any help with
this would be much appreciated. Thank You!

 

[Jeff Boyce]

Michelle

If this were my project, I would:

* open the startup form in design view
* add a command button, using the wizard
* select the wizard choice for form-related actions and Open a Form
* select the (second) form to be open
* select the appearance of the command button
* finish, and test.

What's happening when you do that?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Ok so that worked for open form, but what if I want to add a new record using
the form i am opening. ie: I want an add new record on my opening page. i can
make one easily in my main form because they are connected but not from my
startup page. Is that not possible??? Thanks for the help!

 

[Jeff Boyce]

Michelle

Sorry, I'm not visualizing what you are trying to do...

"add a new record using the form I am opening..." -- that's how I add new
records. Are you saying you open a form, but cannot add a new record? What
can you do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

ok, ill try to explain better, im sorry.

I am trying to create my startup page so when a user opens the database it
is the first thing they see. I am placing diffrent command buttons in a blank
form. one of the buttons i would like to create is an add a new record using
the form I created that is connected to my main database. I can create a
button that opens the form I want but I want a blank form to open so new
information can be added. does that make sense?
Thanks

 

[Jeff Boyce]

Ahhh... So you want the new form to open in Date Entry mode, right?

Two options -- one is to make the form's Data Entry property = Yes; second
is to use the DoCmd.OpenForm ... syntax to specify opening in DataEntry mode
(check Access HELP for this).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

THANK YOU!!!! It works!

Ahhh... So you want the new form to open in Date Entry mode, right?

Two options -- one is to make the form's Data Entry property = Yes; second
is to use the DoCmd.OpenForm ... syntax to specify opening in DataEntry mode
(check Access HELP for this).

Regards

Jeff Boyce
Microsoft Office/Access MVP