Question Locked

Access - filter problem

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have used a filter to use in one of the forms to search for spesific records, but when ever the result is null it freezes the system and hide all the contents in the form,
the filter that I used is: DoCmd.ApplyFilter filter, "[Nom de contact] LIKE ""*" + Me.Text48.Text + "*"""

what is the simplist way to solve this?

thank you in advance.
Carlos

2 replies

by mattohare

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

If (Me.Text48.Text <> "") Then
DoCmd.Apply.....
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.

This discussion is closed to new replies.