I would like to set up a parameter query which asks the user to select a code
from a choice of 60+. How do I set up this query so that it provides a
dropdown box for the user toselect the correct code rather than having to
type it in? I do have a table with these codes in.
Is the query the end result or is the query to be used as the record
source for a report?
The following is if the query is the end result.
You cannot use a combo box in a query prompt.
You'll need to use a form to do this.
Make a new unbound form or use an existing form.
Add a combo box that will show the CodeID field.
Make sure the Combo Box Bound Column is the
same DataType as the CodeID field.
Add a command button.
Code the button's Click event:
DoCmd.OpenQuery "QueryName"
DoCmd.Close acForm, Me.Name
Name this form "ParamForm"
Code the Query CodeID field's criteria line
forms!ParamForm!ComboBoxName
Open the form.
Find the CodeID in the combo box.
Click the command button.
The query will display just those records selected.
The Form will close.