xtraterrestrial
Programmer
Hi,
I tried to write some information to a table by opening a recordset but I get the following error "Update or Cancel Update Without AddNew or Edit"
This is what a basically have,
Dim rs As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb
Set rs = db.OpenRecordset("qryRole2"
rs!History = logEntry & rs!History
(logEntry is a String variable and i am trying to append to the history field)
Any help will be appreciated
I tried to write some information to a table by opening a recordset but I get the following error "Update or Cancel Update Without AddNew or Edit"
This is what a basically have,
Dim rs As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb
Set rs = db.OpenRecordset("qryRole2"
rs!History = logEntry & rs!History
(logEntry is a String variable and i am trying to append to the history field)
Any help will be appreciated