Set criteria and have information display in form

  • Thread starter Thread starter BrookieOU
  • Start date Start date
B

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