Using macros to change a query's content

M

Mike Waters

Hello,
I currently am using a macro to print out several
reprots that I use on a regular basis. When the macro
runs, it sets criteria for the report before printing it.
This works fine if the query they run off of is blank.
The problem is from time to time I run the query with
certian criteria in it, and if I forget to save it blank
again, when I run the macro for the report, I don't get a
correct report. I can't seem to get a macro to set the
criteria in a query to blank fields before running the
macro. If anyone has any suggestions, please E-mail me at
(e-mail address removed)

Thank you,
Mike
 

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

Top