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

How do I remove the top half of a block interval? 1
DLookup in Continuous form 0
Split form 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Sharepoint not capturing staff name when automation runs 0
Adding data to MS Access from csv file 0
Creating a Chart on form from selected data in query. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top