One More Question on Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
SCHNYDES said:
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?
Click to expand...

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.
 
Back
Top