Full Version: How to resuse data from a query prompt
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
srivers80
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
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.
srivers80
that worked! thank you!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.