Questions

Access - filter problem

+
0 Votes
Locked

Access - filter problem

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
  • +
    0 Votes
    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.

  • +
    0 Votes
    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.