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
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Answers (1)
0
Votes
Put in section of if code
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.
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.
4th Apr 2007
