Set criteria and have information display in form

[BrookieOU]

I would like to use combo boxes to set the criteria from a parameter query (I
can do that part) on the top of a form and then display the information in a
split/subform at the bottom. I don't know how to do that part. Any
suggestions?

Thanks,
Brooke

 

[KARL DEWEY]

Open the query in design view, scroll to field that has combo box as
criteria, highlight criteria, copy, scroll to right to an empty field, and
paste/edit like this --
CriteriaField: [Forms]![MyFormName]![Combo3]
The data selected in the combo will appear in the output field
'CriteriaField' to be used like any other field.
If you have criteria such as Between [xxxx] AND [yyyy] then you may make
two fields or concatenate them like [xxxx] & " - " & [yyyy] to display
both in one field.