Error 3188

[Angela]

On a form that is tied to a table, the user changes a field called "status".
When that field is changed, a few related records in the same table also need
to change. In the AfterUpdate event, I inserted a procedure that created a
recordset on the table which found the related records and attempts to update
them. However, I am getting the "3188 error". The recordset does not
include the same record that is being modified on the form. The database is
set to "no locks" and "open with record locking" is unchecked. What am I
doing wrong?
Thanks
Angela

 

[Angela]

I guess I've answered my own question by trial and error. I changed the
form's default to 'no records' and the procedure works. I then changed the
database record-locking back to 'edited record' and the procedure still
worked. I then changed the form's record-locking back to 'edited record' and
inexplicably, the procedure now works under that scenario also.