One way to do this is to have a form open with a field that contains the value. Then just point to that field using something like the following for the value in your query.
The form doesn't have to be visible, but it does have to be open.
If the user has to input the value each time the query runs you can use a syntax similar to...
[Please enter _whatever_]
And a third option is to use a function in your code.
Global xxxValueForQuery as ...
Public Function ValueForQuery () as ...
ValueForQuery = xxxValueForQuery
Before calling the query set xxxValueForQuery
. In the query use ValueForQuery()
wherever you need it.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group