Parameter Query Question

[muirchez]

OK, this should be possible but not sure how.............

I am using a parameter query which prompts the user for a code to search/select records by. The problem is that the codes are fairly complex and can easily result in typos when entering them in the query dialogue box.

In the form these different code values are stored in a combo box drop down menu. What I want to do is use a parameter query but use the options from the combo box to eliminate any typos from the user resulting in inaccurate search results.

Is this possible and if so how???

Any help/advice greatly appreciated.
Thanks in advance

 

[ColinEssex]

Create your own search form with the ComboBox on it. Set "LimitToList" as Yes.

Col

 

[neileg]

In your query, instead of the prompt, point the criterion to the combo on the form. The syntax for this is:
Forms!NameOfYourForm.NameOfYourCombo

 

[muirchez]

Many Thanks

Cheers for the prompt responses, will try later on at work.