Query using data

R

Richard

Is it posible for when you set up a combo box and set it to remember value
for later use. How do you use this data in a query as criteria

Many thanks
 
J

Jackie L

When you set up a combo box to remember a value, that means that the value is stored in a table. If you want to use that current field as criteria in your query, make sure the record you want has the focus. Your criteria line could look something like this:
Forms![frmDataInput]![ComboBoxName]

You can also use an unbound combo box as criteria in a query.

Hope this helps.
 
Top