Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Answered: Validation Question

    Hi All,

    I have the code below that works, but I also want it to validate based on the employer too.

    strCriteria = "[division] = '" & Me.Region_ & "'"

    When I try

    strCriteria = "[division] = '" & Me.Region_ & [client_name]= '" & me.employer & "'"

    I get a syntax error. I'm thinking there's an easy way to do this that I'm missing out on. Thanks.

  2. Best Answer
    Posted by Sinndho

    "The logical operator AND is missing:
    Code:
    strCriteria = "[division] = '" & Me.Region_ & "' AND [client_name]= '" & me.employer & "'"
    "


  3. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    The logical operator AND is missing:
    Code:
    strCriteria = "[division] = '" & Me.Region_ & "' AND [client_name]= '" & me.employer & "'"
    Have a nice day!

  4. #3
    Join Date
    Oct 2007
    Posts
    214
    I must be blind. Worked like a charm. Thank you!

  5. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •