Filtering by entry box (1 Viewer)

[Lanason]

Hmmm looked at various posts in here but can't get me code to work

I an trying to filter records based on entered text in a box on the header
so if the Doc No or Doc title contain the entered text it filters by it . . where am I going wrong??:banghead:

    Me.Filter = "[DocNo] like " & Chr(34) & "*" & Me.search & "*" & Chr(34) & " " & "OR [DocTitle] like " & Chr(34) & "*" & Me.search & "*" & Chr(34)

    Me.FilterOn = True

 

[pbaldy]

What's happening/not happening? What does the finished string look like?

Debug.Print "[DocNo] like " & Chr(34) & "*" & Me.search & "*" & Chr(34) & " " & "OR [DocTitle] like " & Chr(34) & "*" & Me.search & "*" & Chr(34)

 

[Lanason]

How bizzare - now it seems to be working . .
not quite sure what I changed

 

[pbaldy]

I fixed it remotely...