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
 
Back
Top