drop down menu's in query's

[matt330]

I'm a new access user and surrounded by 3 1000 page access books and I can't seem to find the answer to this seemingly simple question. I really have tried.

I have a query that prompts the user for specific criteria. How do I make this query prompt a drop down menu rather than just free text, where the user is forced to know and enter exactly what their options are for the criteria.

any help is much appreciated. Thanks in advance!

 

[raskew]

Hi -

You won't be able to include a combo-box directly into your query. You can however switch your methodology and have the user select from a combo-box
on a form, then use that selection to fill the parameter.

HTH - Bob

 

[matt330]

Thanks for the reply Bob. That's precisely what I've been trying, sorry if I didn't word the question correctly. I've gone back and tried making the combo box, building an event when a selection is made that will open the report where [ComboBox selection]=[box on report where user would otherwise be prompted] or [querywhere user would be selected].

Not sure where I'm going wrong. I feel like I'm close but the solution just keeps alluding me.