Expand|Select|Wrap|Line Numbers
- Private Sub CheckFilter()
- Dim strFilter As String, strOldFilter As String
- strOldFilter = Me.Filter
- If Me.LSI_Case_Number > "" Then _
- strFilter = strFilter & _
- " AND ( [LSI Case Number] LIKE '" & Me.LSI_Case_Number & "')"
- If Me.Broker > "" Then _
- strFilter = strFilter & _
- " AND ([Broker]='" & Me.Broker & "')"
- If Me.Insured_Name > "" Then _
- strFilter = strFilter & _
- " AND ([Insured Name] Like '" & Me.Insured_Name & "')"
- If Me.Agemin > "" Then _
- strFilter = strFilter & _
- " AND ([Age]='" & Me.Agemin & "')"
- If Me.agemax > "" Then _
- strFilter = strFilter & _
- " AND ([Age]='" & Me.agemax & "')"
- If strFilter > "" Then strFilter = Mid(strFilter, 6)
- If strFilter <> strOldFilter Then
- Me.Filter = strFilter
- Me.FilterOn = (strFilter > "")
- qdf.SQL = strFilter
- End If
- qdf.Close
- End Sub
IIf(IsNull([Forms]![Query]![Broker]),"",[Forms]![Query]![Broker]). It still prompts me to fill in a value for broker when I open the query.
I don't know where to go from here.