How to programmatically set the LIKE variable in a DoCmd open form filter (1 Viewer)

MarkA70

Registered User.
Local time
Today, 05:28
Joined
Jan 30, 2016
Messages
43
I need to set the Variable for the LIKE portion of a DoCmd form filter to an external value. If I use the filter without the LIKE it is no problem, that is, I can set the value of the Filter as "Last = Forms![frm_Hidden]![Hidden_txt0]", when using the LIKE I cannot get it to work, even though the value in the txt0 is X* where X is any alpha character. What do I need to do?????
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:28
Joined
May 7, 2009
Messages
19,245
"[Last] Like '*" & Forms![frm_Hidden]![Hidden_txt0] & "*';"
 

Users who are viewing this thread

Top Bottom