I currently have the following code linked to a button on my form. I am trying to create a multi-filter. So a user could enter data in Text28 or Text33 and then click the button to run the filter. I tried to set this up with cases to say if text28 is not null then apply filter, and if it is null move on to the next case. Currently, then code is not working. Would I need to define Text28 somewhere in my code. Any idea on how to fix this? Thanks
Code:
Private Sub DisplayDelegation_Click()
Select Case Text28 Is Not Null
Case True
Me.Filter = "LOAN_NUMBER = " & Me.Text28
Me.FilterOn = True
Me.Requery
Case False
End Select
Select Case Text33 Is Not Null
Case True
Me.Filter = "OTHER_LOAN_NUMBER = " & Me.Text33
Me.FilterOn = True
Me.Requery
End Select