lookup input prompt

  • Thread starter Thread starter Mer
  • Start date Start date
M

Mer

How do I insert a combo box or look up list in an input prompt for Query? or
something similar?
 
Use a form and then refer to it in the criteria row in the query like this
[Forms]![FormName]![ComboBoxName]
 
Combo Boxes and List Boxes are controls used on forms.

I am assuming that you are attempting to open another form which uses your
query as the RecordSource and then filter the resulting records with the
criteria related to the value in the Combo Box.

If that is the case then on the After_Update event of these controls use the
value of the control as the criteria for opening the form.

Jack Cannon
 
Thanks for your help.

RonaldoOneNil said:
Use a form and then refer to it in the criteria row in the query like this
[Forms]![FormName]![ComboBoxName]

Mer said:
How do I insert a combo box or look up list in an input prompt for Query? or
something similar?
Click to expand...
Click to expand...
 
Thanks for your help.

Jack Cannon said:
Combo Boxes and List Boxes are controls used on forms.

I am assuming that you are attempting to open another form which uses your
query as the RecordSource and then filter the resulting records with the
criteria related to the value in the Combo Box.

If that is the case then on the After_Update event of these controls use the
value of the control as the criteria for opening the form.

Jack Cannon
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue with simple lookup query with form 1
Error on Access Query 10
The usual "Enter Parameter Value" prompt with combo boxes 4
Using criteria in Query 4
Help! on filtering a report using a form & query 7
the selection from combo box prints ID column instead of alpha dat 2
Excel Concatenate Form Name to Parse for function 1
Blank combo or list box 1

Back
Top