Combo box for query criteria

[RichiHardie]

Is it possible to use a drop down combo box to specify criteria?

I have a query which asks to select a name ( Criteria [Enter Name] ). What I want is to be able to select from a list of names available.

I create my queries using the Wizards, so specific SQL to enable the above would be appreciated if there is not a straight forward solution.

Thanks

Richard

 

[RichiHardie]

Thanks Tony, I'll let you know how I got on.

Richard

 

[RichiHardie]

Tony,

Didn't manage to use your solution, though it did help me move on from my blinkered approach. I solved my problem by using a form/sub-form routine.

Thanks, Richard