I have a form that has detail records. I have 2 combo boxes that I would like to use to filter the detail records on the form with. I have tried the following and does not seem to work. How can this be done?
Dim strFilter As String
Dim strFilter2 As String
strFilter = "Make = '" & Combo136.Value & "'"
strFilter2 = "Type = '" & Combo138.Value & "'"
Me.Filter = strFilter
Me.Filter = strFilter2