Use form?? for date in Multiple queries

[RogerD]

I have a db that is used for forecasting material requirements. There are multiple queries in the db that work great with . but instead of typing in the date for each query, I would like to use a form?? or whatever works best to only enter the date one time. I have seen threads that almost get me there, and I know it can be done, just don't know how.

thanks in advance for your help.

[CJ_London]

right click on your criteria and select expression builder. Then navigate to the control on your form. Note the form needs to be open for the query to work. You should end up with something that looks a bit like this

=[Forms]![NameofForm]!NameofControl]

[RogerD]

thanks for the quick response.

works great!
now, I wrote a macro to test if it can be entered once or if it has to be entered multiple times.

when I run the macro to update 3 queries, I have to enter the date 3 times.
what do I need to do to only enter the date once?

[RogerD]

BTW
This is the first time I have used the expression builder in this way. I have used it in the past multiple times for calculations, but this is the first time using it to call a form.
thanks for the info!

[CJ_London]

sorry - don't use macros so not sure what a solution might be. If you run a query and the form is open and has not been closed, you should not need to enter the date again. Suggest post a new thread in the macro forum

Be aware that Date is a reserved word - it means today, suggest rename your control something like txtDate. Using reserved words can result in unexpected errors, often with misleading error messages.

See this link for a list of reserved words

https://support.office.com/en-us/art...7-da237c63eabe

take note in particular para 2

[RogerD]

I read in an earlier post from you, "the form needs to be open", so, I opened the form, entered the date, ran the macro.
all 3 queries ran with the date entered in the Form.
I also changed the "Dates" to "TxtDates".
I was calling the form from the macro before I re-read your post about the form.
Thanks for your help!!
the staff that will be using this for MRP, thank you also!!