I have a form I am trying to filter using "dynamic" criteria (not sure what else to call it). The user can select what field they want to filter on from a combobox and then what criteria from that field. I am not sure of the syntax for the filter. This is what I have. When I click the button, it filters out everything.
Private Sub btnFilter_Click()
If Not IsNull(Me.cboSrchField1.Value) Then
Master.Form.Filter = " & me.cboSrchField1 & " = " & Me.cbofilterfld1 & "
Master.Form.FilterOn = True