Using Like to Filter a form.

  • Thread starter Thread starter himmelrich
  • Start date Start date
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.
 
DoCmd.ApplyFilter , "[Project Name] Like '*" & Forms![Project
Search]!Combo99 & "*'"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Apply a filter from user input using "Like" 12
filtering a form based on the values of a subform 0
Trouble Filtering a Sub Form With Combo Box Options 2
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
Filter a list containing null values 3
Form Filter question 1
Open a set or single form from a value based in a combo box 1
Isnull with a filter problem 4

Back
Top