Using Like to Filter a form.

H

himmelrich

When I put [Project Name] Like "*" & Forms![Project Search]!Combo47 &
"*" in a query against field project name is works great.

My implementation of this is to be in a form with an unbound text box
with an event 'After Update' that looks like this:

DoCmd.ApplyFilter , [Project Name] Like "*" & Forms![Project Search]!
Combo99 & "*"

this implementation is not working so I'm a little lost still as to
how this may work.

I'm able to do this with an exact match on another field/form, but
with Like it's a different story....I'm not sure why, but perhaps you
can help.
 
K

Ken Snell \(MVP\)

DoCmd.ApplyFilter , "[Project Name] Like '*" & Forms![Project
Search]!Combo99 & "*'"
 
Top