close a form upon opening another.

  • Thread starter Thread starter postman
  • Start date Start date
P

postman

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.
 
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



--
Doug Steele, Microsoft Access MVP

(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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open & Close forms 2
Opening One Form From Another and Minimizing the First 6
How do you render a record in a continuous Data Entry Form? 10
Access Sub form opens before the main form in MS Access 0
Access Automatically Send a notification email once a record is added 0
Form Filtering 1
Open Form On Close 1
Close a form when it loses focus 11

Back
Top