Entering a date once only for four different queries?

[chuckles1066]

I have a macro that runs four different queries.

Each query needs a date entered (it's the same for each query).

I originally had an [Enter date:] criteria in each query but assumed that using a function and grabbing the initial user input would be enough to fire all four queries without having to enter the date each time.

Wrong!

So my question is: how do I grab that initial user input and store it for use in subsequent queries?

TIA.

 

[Joe4]

One trick that I often use is to create a one-record Table that holds criteria to be used for many different queries. I then usually have a criteria Form based on this table where users can easily enter the desired criteria.

I then link that table into all of my queries that depend on that value. So they only need to update it one place.
You can even create a command button on that same criteria form to call and run your queries. So it can all happen from one place.

 

[boblarson]

So my question is: how do I grab that initial user input and store it for use in subsequent queries?

Use a FORM for collecting the input and then leave it open while you process the queries.