Access - filter problem

0 Votes

Access - filter problem

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.
0 Votes
Collapse -

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.