id="info"

Question

Locked

Access - filter problem

By carlos.maalouf ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Put in section of if code

by mattohare In reply to Access - filter problem

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.

Back to Windows Forum
2 total posts (Page 1 of 1)  

Operating Systems Forums