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
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