Date help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 29 Jul 2004 15:57 GMT

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

Reply to this Message

tina - 29 Jul 2004 17:54 GMT

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

> 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
[quoted text clipped - 5 lines]
> Thanks in advance,
> JOHN

Reply to this Message