Link to home
Start Free TrialLog in
Avatar of TimTDP
TimTDP

asked on

Use "like" in Docmd.ApplyFilter

I need to filter records on a form.

I use the following code:
DoCmd.ApplyFilter , "StudentLastName = '" & Me.StudentDetails & "'"

This works well if the user enters the exact criterea.

I would like to add a "*" to the criterea so that if the user enters "on", the following are returned:
anyone
on
once
etc

What is the syntax?

ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial