Macro Question

  • Thread starter Thread starter HeatherD25
  • Start date Start date
H

HeatherD25

I wrote a simple macro --

It runs query 1, then closes it. Runs query 2, then closes it. Runs query
3, then closes. Finally, opens a report.

(I had to run 3 queries to get the data I needed by the 3rd query and the
report uses the 3rd query to display the data.)

I have a button on a form that runs the macro. After I click the button the
screen flashes 3 times and then opens the report. Is this because of the
queries? Is there a way to stop the flashing?

Thanks!
Heather
 
If these queries are feeding data to each other and the report just have the
macro open the report only. No need to open query and close unless you are
update, appending, or deleting records.
 
Back
Top