Hello,
I have a form that i currently filter using a single combobox.
A user makes a selection in the combobox and clicks ok. I then opens the next form with the filtered results.
How would i do this to incorporate 2 comboboxes where the form would have to match both criterias when it filters?
This is the code i currently use for a single combo
I have a form that i currently filter using a single combobox.
A user makes a selection in the combobox and clicks ok. I then opens the next form with the filtered results.
How would i do this to incorporate 2 comboboxes where the form would have to match both criterias when it filters?
This is the code i currently use for a single combo
Code:
Private Sub cmdOK_Click()
DoCmd.OpenForm "frm1", , , "[ID] = " & Me.cbo1
End Sub
