Return to switchboard form when query closes

  • Thread starter Thread starter KHogwood-Thompson
  • Start date Start date
K

KHogwood-Thompson

Hi All,

I have a switchboard form that contains an instruction to run a macro, which
effectively opens a query. I have the database window hidden and the macro
closes the switchboard prior to the query opening.

What I need is when the query closes, the switchboard form to re-open. Is
that possible and if so how do I achieve it??
 
On Thu, 26 Mar 2009 05:23:02 -0700, KHogwood-Thompson

That is not possible. And you should not allow users in your queries,
but rather create forms (perhaps in datasheet view) and reports for
them to see / edit the data.
Once you do, you get the control you seek, for example in the
Form_Close event you can show the Switchboard form again.

-Tom.
Microsoft Access MVP
 
Many thanks Tom, I will bear that it mind and create the form or report that
you refer to.

Thanks again,
 
Back
Top