Date help

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am making a macro to take things from 4 different tables
and I want them to pull all of the same dates. In the
queries I have conditions and those work, the only problem
is when someone runs the macro you have to type the date
in 4 times. Is there a way that I can make it so that I
can type the date in once and it will carry through all
the queries in the macro?
Thanks in advance,
JOHN
 
you can put a textbox on a form, we'll call it txtDate, and set the criteria
of each query to point to that control, as

Forms!MyFormName!txtDate

suggest you set the textbox's InputMask to a date format, to help ensure
valid entries by the user.

hth
 
Back
Top