combo box in a query criteria

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

Guest

Hi All,

I have a query were I get the Qty on hand of items based on a project. The
query works fine and to get the users input i have in the criteria a prompt
asking the user the project no and the query shows filtered records for that
project.

My question is how can i make this prompt a combo box containing my project
nos so that the user can select values from the combo or list box. any ideas
or direction would be appreciated. I am not sure how to proceed with this.

thanks in advance
 
The combo box must be on a form. You would need to open the form, select
from the combo box, and then run the query.
Criteria in the query would reference the combo box like this ---
WHERE YourField = [Forms]![YourFormName]![YourComboBox]
 
Hi Karl,

It worked like a charm. I have a form with a combo box and a button to run
the query and it does work. Thanks a ton for all your help.


KARL DEWEY said:
The combo box must be on a form. You would need to open the form, select
from the combo box, and then run the query.
Criteria in the query would reference the combo box like this ---
WHERE YourField = [Forms]![YourFormName]![YourComboBox]

--
KARL DEWEY
Build a little - Test a little


vandy said:
Hi All,

I have a query were I get the Qty on hand of items based on a project. The
query works fine and to get the users input i have in the criteria a prompt
asking the user the project no and the query shows filtered records for that
project.

My question is how can i make this prompt a combo box containing my project
nos so that the user can select values from the combo or list box. any ideas
or direction would be appreciated. I am not sure how to proceed with this.

thanks in advance
Click to expand...
Click to expand...
 
Back
Top