srivers80
Dec 31 2009, 11:09 AM
I would like to resuse data from a query prompt. For example, I prompt the users to enter a date for a sales query and I would like to resuse that date instead of prompting the user to re-enter that date. thank you
Peter46
Dec 31 2009, 11:12 AM
There isn't any way of passing parameters from one query to another.
You can use a textbox on a form to enter the date and you can then refer to it in any query you want to run..
Syntax is..
Forms!formname!textboxname
The form must be open when you run the query.