setting a date for all queries in a DB

[farnorth]

Is there a way I can set a form field that will set the date endered as the date all queries work off of?

Currently I have the date set to Date() but I want the user to enter a date that will drive all data queries in the db.

Thanks.

 

[RickSpr]

Do you know how to refer to a form field within a query, using the syntax Forms!<form name>!<control name>? Just modify each of your queries to refer to the same date control on the same form.

Remember that the form must remain open at all times that one of these queries may be opened. You will probably want to hide the form, rather than close it, after the date has been entered. Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein