The problem is that your modifications via code are dirtying the record
after it has been saved.  If you try to move to a new record, thereby saving
the record then redirtying it, your record will be dirtied again, ad
infinitum.  If you move your code to the form's BeforeUpdate event, the
changes will be made prior to the initial save, and the vicious circle of
saving and redirtying will be avoided.

HTH,
Nicole

Private Sub Form_AfterUpdate()
    dtmChangeDate = Now()
    strLastUser = strLogon
End Sub

The first line sets the dtmChangeDate field to
the current date and time and the second line
sets the value of the strLastUser field to the
variable strLogin which is assigned when the
database is opened. My problem is that if a
record is changed, the updates to the fields take
place, but the current record stays displayed.
When I click the next record button (on the
Navigation buttons), it won't move to the next
record. I can move to other records if I do not
makes changes to the records. What lines of code
do I need to add to the After Update event?

Thanks for the help.

Cliff

Sent via Deja.com http://www.deja.com/
Before you buy.