combo box in a query criteria

[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

 

[Guest]

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]

 

[Guest]

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.

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

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