lookup input prompt

M

Mer

How do I insert a combo box or look up list in an input prompt for Query? or
something similar?
 
R

RonaldoOneNil

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

Jack Cannon

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
 
M

Mer

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...
 
M

Mer

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...
 
Top