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