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

On Thu, 13 May 2004 10:28:34 -0700, Suki wrote:

> 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

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

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.