Date help

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
 
T

tina

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
 

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

Similar Threads

Drop down list control value in vba 2
Consolidation Table from Different Excel Tabs with Different Format 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Clearing Fields in a Word Form 5
Finding the proper style field and the numbered paragraph value within the style 0
Creating a Chart on form from selected data in query. 0
Autofill Date in Word 15.33 for Mac 0
Finding the right style field in VBA 0

Top