• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Open form using Like and LEFT

Experts, I am trying to open a form with 2 LiKE conditions.  I am getting a datatype mismatch error.  I only get this error after adding the second like condtion.  If I leave as only 1 LIKE condition then it works.  

DoCmd.OpenForm "Project Datasheet subform_3", acFormDS, , "[End User] Like '" & Left(Me.txtEndUser, 4) & "*'" Or "[UltimateEndUser] Like '" & Left(Me.txtEndUser, 4) & "*'", , acDialog

thank you
0
pdvsa
Asked:
pdvsa
1 Solution
 
Shaun KlineLead Software EngineerCommented:
Try this

"[End User] Like '" & Left(Me.txtEndUser, 4) & "*' Or [UltimateEndUser] Like '" & Left(Me.txtEndUser, 4) & "*'",
0
 
pdvsaProject financeAuthor Commented:
Perfect.  I see I  had an extra double quote.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now