Re: unable to move to the next record after editing

[alicejwz]

Re: unable to move to the next record after editing

Hi all,

I'm having trouble moving to next record after making a change in the subform. I have eight checkboxes, previous and next buttons in the subform. After reselecting a check box When I click on either previous or next button I get one of these messages.
I'm hoping someone can provide an explanation or a solution.
Thanks for your input.


MS VB:
Run-time error ‘2115’
The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing MS Access from saving the data in the field.
End Debug

Occurred cmdPrevious_click event
Set rst = Me.Recordset
Set rstclone = Me.RecordsetClone
--> DoCmd.RunCommand acCmdSaveRecord
rstclone.Bookmark = rst.Bookmark
rst.MovePrevious
rst.MoveNext
or
if I leave the docmd.runcommand out this error message will appear:
Row cannot be located for updating. Some values may have been changed since it was last read.
Set rst = Me.Recordset
Set rstclone = Me.RecordsetClone
rstclone.Bookmark = rst.Bookmark
error here--> rst.MovePrevious
rst.MoveNext