User-defined search using combo box

[Claire Simkins]

I've set up a user interface to allow users to click a button to search our
customer database by surname - this brings up a popup asking them to enter
the first few letters of surname, but I also want to include another search
where the user clicks a button to search the customer database by shop and is
asked to select a shop from a distinct list of shops from the 'shop' field of
my database.

How do you set up a user-defined search where the prompt is to select from a
combo box rather than entering text?

I'm sure this is straightforward, but I haven't used Access for years and am
struggling to remember!

Thanks for your help.

Claire

 

[JackP]

set the selection criteria in the query to be :
Like [Forms]![FrmSelection]![Shop]

where FrmSelection is the name of your form and Shop is the name of your
combo box.