Mar 20, 2013 #1 fileman1 Technical User Joined Feb 7, 2013 Messages 152 Location GB I am trying to find if 2 items are already in a recordset. rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2 It errors saying something missing in syntax.
I am trying to find if 2 items are already in a recordset. rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2 It errors saying something missing in syntax.
Mar 20, 2013 1 #2 MajP Technical User Joined Aug 27, 2005 Messages 9,382 Location US lets assume that ID1 = 1, and PK1 = 2 rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2 would resolve to ID1 =1KeywordID =2 rs3.FindFirst "ID1 = " & PK1 & " AND KeywordID = " & PK2 This would resolve to ID1 = 1 AND KeywordID = 2 Upvote 0 Downvote
lets assume that ID1 = 1, and PK1 = 2 rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2 would resolve to ID1 =1KeywordID =2 rs3.FindFirst "ID1 = " & PK1 & " AND KeywordID = " & PK2 This would resolve to ID1 = 1 AND KeywordID = 2
Mar 20, 2013 Thread starter #3 fileman1 Technical User Joined Feb 7, 2013 Messages 152 Location GB Many thanks for the help, and clear explanation. Upvote 0 Downvote