Hi See code below.
I have added a new field "AuditCategory" onto my tblAuditlog.
My VBA insert to this table previously worked but now I want to add this new field to the insert statement..
How Do I add the variable "strAuditCategory" into my insert statement - (it should be written to the field name AuditCategory obviously).
I have tried a few combinations but have got confused by the quotes, commas etc. (This confusion is a speciality of mine!)
CurrentDb.Execute "insert into [tblAuditlog] (Auditstr,auditDate) values ( '" & AuditDetails & "',#" & Now() & " #)"