Hi All,
I am trying to filter a continuous form based on the value of a text box
within the same form. I have 2 fields I am trying to use in my where clause
but keep getting a Type Mismatch each time it executes. It works fine if I
comment out before the OR!!!
The code is:
DoCmd.ApplyFilter , "star1 like '*" & Me.txt_Search_Criteria.Value & "*'" Or
_
"star2 like '*" & Me.txt_Search_Criteria.Value & "*'"
I've tried the help section but to no avail. Could anyone please point me in
the right direction?
TIA,
Mark