Combo Box Filter for a Form

[cwassel]

I have a combo box on a form that I want to apply a filter to my form. The combo box is populated with choices such as "Round 1", "Round 2", etc. "Round 1" and "Round 2" are the PeriodID for the records on the form. I want the user to be able to select the Round from the combo box and have the form filter to show only those records with a matching PeriodID. How would I write this code for the filter? Thanks for your time and help!

 

[misscrf]

You should be able to use a wizard. If you have your form set up and you plop the combo down, let the wizard come up, and tell it that you want it to select records based on your choice. Then point it to the table and field.

misscrf

Management is doing things right, leadership is doing the right things

 

[hkaing79]

In the Open event of the form, populate your combobox using rowsource.

cboFilter.Rowsource="SELECT PeriodID FROM tbl GROUP BY PeriodID ORDER BY PeriodID"

To filter the form, something like...

If Not IsNull(cboFilter) Then
  Me.Filter = "PeriodID='" & cboFilter & "'"
  Me.FilterOn = True
End If