Open form filtered using "like"

  • Thread starter Thread starter hotplate
  • Start date Start date
H

hotplate

Hello,
Is there a way to open a form filtered when a user types in the first 3
or 4 letters and all records starting with those 3 or 4 letters appear.
I tried using the wizard and typing 3 letters and a wildcard in an
unbound control in a form, but it did not work, it looked for "Pro*"
instead of Like "Pro*".

James
 
What does your code look like? I'm assuming you've got something like:

stCriteria = "Field = '" & Forms!FormName!ControlName & "'"

Change that to

stCriteria = "Field Like '" & Forms!FormName!ControlName & "*'"
 
Back
Top