I recently watched one of Richard's videos on how to create a change log. I watched the video and enter the code as such. But it keeps giving me a run-time error 3075- syntax error "missing operator" in query expression 'ProjectID=' the complete line of code is -
DoCmd.RunSQL "INSERT INTO ProjectsChangeLog SELECT * FROM ProjectsForm " & _ "WHERE ProjectID=" & ProjectID
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
