close a form upon opening another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

postman - 10 Mar 2005 23:53 GMT

How to automatically close a form upon opening another.

I have two forms, the first prepares data for the second form, and have the same table. The second form is opened from a control button on the first.
I would like the first form to be closed when that button is hit, if possible.

Thanks in advance

Reply to this Message

Douglas J. Steele - 11 Mar 2005 00:11 GMT

In the button's Click event, after you've issued the DoCmd.OpenForm, put
DoCmd.Close acForm, Me.Name:

DoCmd.OpenForm "MyOtherForm"
DoCmd.Close acForm, Me.Name

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

How to automatically close a form upon opening another.

I have two forms, the first prepares data for the second form, and have the
same table. The second form is opened from a control button on the first.
I would like the first form to be closed when that button is hit, if
possible.

Thanks in advance.

Reply to this Message