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.
[Forms]![_frmName_].[_fldname_]
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
End Function
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
http://www.pnwadg.org
Passing a varibale into a query
