Thread: 2 LINK CRITERIA
View Single Post
  #1 (permalink)  
Old July 14th, 2006, 01:42 AM
Vision G Vision G is offline
Authorized User
Points: 250, Level: 4
Points: 250, Level: 4 Points: 250, Level: 4 Points: 250, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2006
Location: , , Greece.
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default 2 LINK CRITERIA

HI ALL,

I HAVE CREATED A BUTTON TO OPEN A FORM WITH A SPECIFIC CRITERIA, BUT I WANT TO JOIN WITH TWO CRITERIA !
HOW SHOULD I DO IT!

Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "2_ERGA"

    stLinkCriteria = "[LAST NAME]=" & "'" & Me![LN] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

I'D LIKE TO OPEN THE FORM, NOT ONLY WITH LAST NAME, BUT ALSO WITH THE 'FIRST NAME' CAUSE I HAVE RECORDS WITH THE SAME LAST NAME AND DIFFERENT FIRST NAMES!

tHANK YOU

!

Reply With Quote