I have this code that I get an error message # 438 - Object doesn't support this object or method.
The code that is highlighted I have pasted below.
strSql = "INSERT INTO [BContacts] ( AddressesCRN, SigningOfficier, PrefixCRN, ContactTitle, [First Name], LastName, WorkPhone, HomePhone, MobilePhone, FaxNumber, Birthdate, ContactNote, E-mail, Extension, Direct, Landlord, Client, Dispositions, Broker, Party, LastUpdateDate, LastUpdateUser, NonClientRetailer ) " & _
"SELECT " & lngAddressID & " As AddressesCRN, SigningOfficier, PrefixCRN, ContactTitle, [First Name], LastName, WorkPhone, HomePhone, MobilePhone, FaxNumber, Birthdate, ContactNote, E-mail, Extension, Direct, Landlord, Client, Dispositions, Broker, Party, LastUpdateDate, LastUpdateUser, NonClientRetailer " & _
"FROM [BContacts] WHERE AddressesCRN = " & Forms.BRolodexFrm.Form.BRolodexAddressSub.Addresse sCRN & ";"
I am not sure what this error message is telling me??!!