After Update

[Jacob]

Access 2003

I placed the following in the After Update event on a form...

'Me.userM = Forms!frmlogin!User.Column(5)
'Me.dateM = Now()

It is meant to loag the persons name and date when a record is changed.
However, after the update is made, you cannot scroll to a new record, either
forward or backward...any ideas why?

 

[GeoffG]

The record has been updated by the time the AfterUpdate event
fires. Try your code in the BeforeUpdate event.

Geoff

 

[GeoffG]

Scratch that.
I thought you weren't trying to save data with the record.

Geoff

 

[GeoffG]

Ignore previous post.
I thought you weren't trying to save data with the record.

(I received a message in Outlook Express saying that my post is
no longer on the server, so I've posted this again.)

Geoff