Holding a query date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My co-worker has a macro that runs three make-table queries and all of them
ask for dates (Between.....And) that his users have to type in........Three
Times. He wants to save the original dates the users type in for all three
queries. By the way, he's doing his reporting for Calendar weeks.

Any ideas? I looked around the forum and didn't see anything. Thanks.
 
If the users enter these dates on a form, then the queries could pull the
dates from that form.

This is typically called a "parameter form" and would include an "ok"
button. That button would hide the form and run the macro. The last line
in the macro would close the parameter form.
 
Good idea. I do parameter forms all the time and it never occured to me.
Ok, I'll tell him. Thanks.
 
Back
Top