how do i send one parameter to macro for multi-queries?

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

Guest

I have a macro that runs several queries, each selects 'today' out of a
different field (activity today each group). I want to change queries to
allow select date. How do i pass ONE parameter to the macro to run the
requested date for all queries in the macro?
Thanks!
 
Create a form and add an unbound text box for the date.
Add a command button on the form that runs the macro. In
the criteria of you queries use
[Forms]![NameOfForm]![NameOfTextbox]

Chris
 
Back
Top