Display Query Results on top of a Form

K

Kristin M

I have a query which runs from a control button on a form. When the query
runs, the results are displayed behind the form. The user then has to
minimize the form in order to see the query results.

How do you set the query results to display on top of the form?
 
J

Jerry Whittle

You could put the following line in the code for the On Click event of the
button being pushed:

DoCmd.Minimize

That will minimize the form and the query should be on top.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a query result to a form in Access 2007 1
Run query based on results of previous query using code 4
Parameter Query Won't Run 0
Close query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Populate my form with parameter query results 1
Disapearing Query Results! 9
How to display query result in text box? 1

Top