One More Question on Parameters

message from =?Utf-8?B?U0NITllERVM=?= on 10 May 2004
I have an access database with multiple forms and queries. Almost all queries use a parameter to view information on what they have. Without using data access pages and cookies, is there a way to continuously have the parameter stick on all paramter queries until the user requests a different parameter? This would solve the issue of typing in the same paramter multiple times, any thoughts?
 
Dirk Goldgar replied to =?Utf-8?B?U0NITllERVM=?= on 11 May 2004
"SCHNYDES" <anonymous@discussions.microsoft.com> wrote in message
news:C911D8C0-456A-4977-94AC-7F9BAF17159B@microsoft.com

Create a form to prompt for the parameter, having the user enter it in a
text box on the form. Have your queries refer to this text box on the
form for their parameters. Leave the form open while you run them
all -- you can make it invisible if you want, until it's time to prompt
the user for a new parameter.
 

Archived message: One More Question on Parameters (MS Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.