Cannot write to record

[xtraterrestrial]

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

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

 

[tatum]

I think you need to edit the record. Something like this:

rs.Edit

rs!History = logEntry & rs!History

rs.Update

The edit opens the current record for editing and the update amkes the changes to the record.

 

[tledwards]

You must first open the recordset to edit the update to save the change like the code below.

rs.Edit
rs!History = logEntry & rs!History
rs.Update