Using InputBox to Change Query Criteria

Hello Experts,
I am trying to reduce the amount of queries I have in my database.  I have a query, lets say QRY1, that is the data source for multiple forms.  I want to use the InputBox to add criteria to that query.  I know I can do this in design view of the query, but I have multiple critera depending on the user and I don't want to have QRY1 with the [] under one field, the QRY2 (the same tables as QRY1) with [] under a different field.  Does this make sense?  Can this be done with the InputBox?  Thanks in advance for all who reply.
cebaker75Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"Can this be done with the InputBox? "

A query cannot reference the InputBox AFAIK.  However, you could have a small pop up form with a text box for criteria ... and have the query reference that text box, like so

Forms.YourFormName.SomeTextBoxName

mx
0
 
cebaker75Author Commented:
Thanks DMX!  That works great.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... you are welcome ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.