Code to close a form Access 2000

  • Thread starter Thread starter Suki
  • Start date Start date
S

Suki

Is it possible to close and open forms in vba
from another form that is being used,
my input form is named Collection and the form
I want to close is called Artist and then open a
form called Location all from the collection form

Hope for help
TIA

Suki
 
Is it possible to close and open forms in vba
from another form that is being used,
my input form is named Collection and the form
I want to close is called Artist and then open a
form called Location all from the collection form

Hope for help
TIA

Suki
Click to expand...

Code an event procedure on the Collection form:
DoCmd.Close acForm, "Artist"
DoCmd.OpenForm "Location"

If you wish to have the "Location" form open as Dialog, then use
DoCmd.OpenForm "Location", , , , , acDialog
 
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

Excel VBA - Problem with Closing Print Preview 0
Access how to open existing database from another database using Access - VBA 0
Opening form unexpectedly closes other form 0
Music Database 1
Need to requery a main form with a pop up form 3
Access Automatically Send a notification email once a record is added 0
If main form is closed, also quit the application 1
moving excell form to access 1

Back
Top