A very simple problem

[Danny B]

Ok, this is going to make me sound really stupid.

When any query-based form which reqiures a user-input parameter runs (i.e. searching for a name or something similar) it brings up a parameter box. If a user decides they then do not want to open this form, and clicks on cancel, how can I make the previous form (i.e. the switchboard) re-open, if a macro closes the switchboard and opens the query-form? At the moment, the database simply stops.

Thanks for your time,

Dan

 

[Jack Cowley]

I don't close switchboards but leave them open as the next form opens on top. Closing the form takes me back to the form that opened it.

hth,
Jack