Combo Boxes

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Can someone please help. I would like to add 3 combo
boxes on a form. Then I add a command button that opens
another form with the criteria of the 3 combo boxes.
Bottoom line, I am trying to create something that will
allow 3 combo box selections and data returned based on
what those 3 choices are.
 
Hi,
I'll try to give you a general overview since you didn't provide any specifics.
The form that will display the results should have a query as it's record source (even if it's
just getting data from one table).
You will reference the 3 combos as criteria (for whatever fields they correspond to)
in your query like this:

=Forms!yourForm!yourCombo1

do that for each of the 3 fields that your 3 combos refer to.

When you open the form, it should be filtered to your criteria.
 
Back
Top