Dual function buttons

C

cutescoot24

How do I create a button that closes the form I have open and opens a
subsequent form? I want this database to flow better than continually
hitting buttons to open and close forms.
 
K

Klatuu

Oops! I think I sent an empty reply by mistake, sorry.

In the Click event of your button:

DoCmd.OpenForm "MyNextForm" 'Opens the next form
DoCmd.Close 'Closes the current form
 
R

Rick Brandt

Klatuu said:
Oops! I think I sent an empty reply by mistake, sorry.

In the Click event of your button:

DoCmd.OpenForm "MyNextForm" 'Opens the next form
DoCmd.Close 'Closes the current form
Click to expand...

Actually, as written that code would likely open the second form and then close
the second form again. If you don't specify DoCmd.Close will close the
currently active object which might very well be the new form.

Either do the close first or (better) explicitly supply the object name...

DoCmd.OpenForm "MyNextForm"
DoCmd.Close acForm, Me.Name
 
K

Klatuu

You are correct, Rick. I just tested it. Specifying the form to close is
necessary. Thanks.
 
Top