Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Location
    Rio Bravo, Mexico
    Posts
    27

    Exclamation Unanswered: LinkCriteria syntax...need help

    stLinkCriteria = "[IdOrderNumber] = " & Me!IdOrderNumbre & "[Group] = " & "1"

    Im trying to call up a report that requires 2 fields in order to print the right info. I know my syntax is wrong, can anybody tell me how to concatinate this criteria the right way.

    thanx
    Carlos

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Try this:

    stLinkCriteria = "[IdOrderNumber] = " & Me!IdOrderNumbre & " and [Group] = 1"
    Inspiration Through Fermentation

  3. #3
    Join Date
    Oct 2002
    Location
    Florida
    Posts
    7
    Also make sure [idOrderNumber] is a number data type, if it is a string data type you will have to add in VBA quotes. It will look like this

    stLinkCriteria = "[IdOrderNumber] = ' " & Me!IdOrderNumbre & " ' and [Group] = 1"

    [/
    Quote Originally Posted by RedNeckGeek
    Try this:

    stLinkCriteria = "[IdOrderNumber] = " & Me!IdOrderNumbre & " and [Group] = 1"

Posting Permissions

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