How do you assign an event to a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a button on my form that has a macro bound to it that minimizes my form as well as runs a query and displays the info to me. What I would really like to be able to do is click a button on the form, and it closes my form and opens the query, and then when I close the query, it will reopen the original form. If it matters, the name of the form is frm_Address, and the name of the query is qry_off.
Any help would be appreciated,
LouD
 
Lou,

It would be better not to open the query datasheet. In fact, this would
be a general principle! You can make another form, which is based on
your query, and instead of opening the query, you can open the second
form. I don't understand the purpose of closing the first form... Why
not just open the second form, and then when you close it, there's the
first one still sitting there?
 
Back
Top