query?

[gbanks]

I have a table called userprojects with 2 fields user and project. I know if I make a parameter query with a criteria of [enter user] under the user field it will ask me the enter a user. The result will show me all the projects for the user name I typed in. The problem is this has to be typed in exactly or the query will fail. Is there any way I can do this with a drop down selection box on a form or in a query? Any help is appreciated. Thanks..

 

[Rich]

Use a combo box based on the table, reference the combo in the query criteria, set the limit to list to yes

 

[Hellfire]

My Problem...!!

Ok, I have a simmilar problem, can anyone PLEASE explain to me how to get this working. I have a table that holds all the available products in my store-room. I want a query to ask my users wich product they are looking for, and then ONLY display that one product.

For example, I have orange juice and Apple juice in my store-room. My usrs run the query, select Apple from the combo-box, and then all the entries with "Apple" in the discription field will be shown.

How do I get a query to work this way?

Can anyone please help?

Thanks