Runtime Error (3075), not sure how to fix it

SD23

Registered User.
Local time
Today, 00:15
Joined
Jun 13, 2006
Messages
60
I get a runtime error and I am not sure what is wrong with the code. The error says Run-Time Error 3075 Extra ) in query expression '([ID]=)'

The code is

DoCmd.SetWarnings False

strquery = "DELETE * FROM [Docket Projects] WHERE ([ID] = " & ID & ")"
DoCmd.RunSQL strquery

strquery = "INSERT INTO [Docket Projects] ([ID],[Project]) Values([ID],[projsl])"
DoCmd.RunSQL strquery

DoCmd.SetWarnings True
 
Perhaps there is a naming problem with the field [ID] and the variable "ID"?
 

Users who are viewing this thread

Back
Top Bottom