Dropdown combined with parameter query

[Guest]

Many of our customers are foreign and have quite unusual names spelt in
tricky ways.
When we run parameter queries looking for data on a particular customer it
is sometimes difficult to get the spelling right and the query doesn't return
any records, even if a wild card is used it can still take several attempts.
Ideally, we would have a dropdown (combo) attached to or appearing before
the parameter dialogue box, that would enable us to pick the customer from
the list without even having to input the name.
Is this possible, and if so could you please give a clear explanation of how
to set it up?
( I got close to this by having a form with a combo on it and the several
query command buttons for the queries right next to the combo, so that the
required name can be copied from the dropdown and then pasted into the
dialogue box, but it isn't ideal....)
Thanks a lot!
CW

 

[Guest]

I got close to this by having a form with a combo on it and the several
query command buttons for the queries right next to the combo, so that the
required name can be copied from the dropdown and then pasted into the
dialogue box, but it isn't ideal....)
No need to copy and paste. In the query just use the combo as criteria like
this --
[Forms]![YourFormName]![ComboboxName]