I have a form that has next and previous record command buttons on it so the user may scroll through a person's records. I also have 2 fields on the form that track who edits a record and when. In the after update property of the form, I set the fields to be equal to the user who is logged in and today's date. The problem is, if a user edits a record, then he/she can not go to the next record. The message says "Cannot go to the specified record. You may be at the end of a recordset." I've pinpointed that it is the updating of the fields that causes that error. Why is that, and how can I get around it? Thanks!
Below is the code I have in the after update property of the form:
Private Sub Form_AfterUpdate() DATE_CHG = date INIT_CHG = [Forms]![login]![User]