Answer for:

Access - filter problem

Message 2 of 2

View entire thread
0 Votes

I assume the null or empty value issue si with Text48 text box. If that's the case:

If (Me.Text48.Text <> "") Then
End if

Where you put your current DoCmd line where I put the place holder. This means the filter will only attempt when there's actually a value in the text box.