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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.