Update Statement VBA Access (1 Viewer)

[hazeleyre23]

Hi,

I am trying to use an UPDATE statement in VBA.

Below is my code, however when I try run it, I am getting an error message.

currentdb.Execute "Update dbo_Agent_Data set ToDate = #" & me!txtUpdateToDate & "# WHERE id_new = " & me!txtUpdateID

the error message I am getting is:

"You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column"

My Identity column column is ID, this is also my Primary Key. Not sure what I need to do next....

Thank you

 

[arnelgp]

then add that in your update sttatement:

currentdb.Execute "Update dbo_Agent_Data set ToDate = #" & me!txtUpdateToDate & "# WHERE id_new = " & me!txtUpdateID, dbSeeChanges

 

[Ranman256]

docmd.runSql "update dboagent..."