to few parameters

  • Thread starter Thread starter Andy G
  • Start date Start date
A

Andy G

I know everyone loves this error. Here is what I'm trying to set:

mySQL =
"SELECT CONTACT_Contact_ID, CONTACT_FirstName, CONTACT_LastName,
CONTACT_City1, CONTACT_State1, CONTACT_Phone1, CONTACT_Phone1_Type,
CONTACT_Email1, CONTACT_LastUpdated
FROM tblCONTACT
WHERE CONTACT_Contact_ID = '" & tempID & "'"

Set rsTemp = CurrentDb().OpenRecordset(mySQL, dbOpenDynaset)

I know it has something to do with the tempID part but I never can get my
single and double quotes right!

Thanks
 
Back
Top