How do you assign an event to a query?

[LouD]

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

[Steve Schapel]

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?

--
Steve Schapel, Microsoft Access MVP

[LouD]

Please disregard this question, I finally realized that I could just
make a form based on the query and use a macro to do what I want.
Thanks anyway.