Forms and command buttons

[Chuckie]

Okay, I have two questions. (I'm new to access)

1)I've created a command button on form1. Now, how do I
get
one of my command buttons to link to form 2? I mean, when
I have someone click on the command button2, I'd like for
it to leave direactly to form2. In addition to that, how
do I get my program to retain the value... that way I can
have that value printed out in a word document after the
entire program has been completed by a user?

2) when I start up access and open my program, how do I
have it prompt automatically one of my forms? I can do it
in excel, but I am unable to have it work for access.

Please help.

Thank you for your time.
any assistance is appreciated =)

 

[Rick Brandt]

Okay, I have two questions. (I'm new to access)

This is more than two questions

1)I've created a command button on form1. Now, how do I
get
one of my command buttons to link to form 2? I mean, when
I have someone click on the command button2, I'd like for
it to leave direactly to form2.

Drop a new button on form1 with the toolbox wizard enabled. One of the wizard
choices for command buttons is for opening another form.


In addition to that, how

do I get my program to retain the value... that way I can
have that value printed out in a word document after the
entire program has been completed by a user?

What is "...the value"? Normally the way to retain values is to store them in either
a variable or in a table (depending on how long you nned to keep it).

2) when I start up access and open my program, how do I
have it prompt automatically one of my forms? I can do it
in excel, but I am unable to have it work for access.

Tools - Startup - Display Form