[MS_AccessPros] Insert Into statement getting syntax error

 

Hi all! Hope your day is going well. I have checked out the following statement and it's the last value that is giving me the problem. It is to be put into the Note and would look like: ListID = 832

I've tried several different approaches and can't get it to work. My guess is that I have more to learn about using quotations.

CurrentDb.Execute "INSERT INTO ListingsMiscCat (ListID, MiscCatID, MiscCatDate, Note) VALUES (" & Me.ReListID & ", 5, " & Me.ListDate & ", ""ListID = """ & Me.ListID & ")", dbFailOnError

Thanks!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___