Code to close a form Access 2000

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
 
F

fredg

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
 
Top