*Query Criteria

I have a query with criteria that looks at a field on a table that refers to
a Lookup table. Currently, I have the criteria ask the user to type the text
for the field. I would rather have the user select from the options on the
look-up table to avoid mispellings...how can I accomplish this?

The best way is to execute the query from a form. Use a combo box to display
the items from your lookup table, then in the criteria line of your query
enter a reference to the control on your form. It will look something like:

Form![YourFormName]![cbo_yourComboName]

The other way to do this is to right-click in the criteria line, Select
Build. Then double click on Forms, double click All Forms, and then click on
the form you are using. As soon as select a specific form, the middle list
will display all of the controls on that form. Double click on the control
that contains your list (you should now see a reference to a control similiar
to the one above in the text box) and then click OK.

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.


"Cheese" wrote:

I have a query with criteria that looks at a field on a table that refers to
a Lookup table. Currently, I have the criteria ask the user to type the text
for the field. I would rather have the user select from the options on the
look-up table to avoid mispellings...how can I accomplish this?

Sorry it took me a while to come back to you, In the previous post I wrote
that the path to the combo when it located in the sub form is different

Forms![MainFormName]![SubFormControlName].Form![StatusChange]

--
Good Luck
BS"D


"Cheese" wrote:

I have a query with criteria that looks at a field on a table that refers to
a Lookup table. Currently, I have the criteria ask the user to type the text
for the field. I would rather have the user select from the options on the
look-up table to avoid mispellings...how can I accomplish this?