Enter date/time into table

[MeSteve]

I am trying to enter a date updated into a table when the record is updated
thru a form. I currently have a Form_AfterUpdate event where the action is
'DateUpdated = Now'. After the update is made and I select a new field, I
cannot move to a new record, Why?

 

[Jeanette Cunningham]

Steve,
check the cycle property (property dialog, Other tab). If it is set to
current record, change it to all records.
When you say >After the update is made and I select a new field, I

cannot move to a new record, I am a bit puzzled. Normally the before
update and after update events fire when you either click a save button or
click the new record button.

How is your form navigating to the new record? Does your form have a save
button or a new record button?

Jeanette Cunningham

 

[John W. Vinson]

I am trying to enter a date updated into a table when the record is updated
thru a form. I currently have a Form_AfterUpdate event where the action is
'DateUpdated = Now'. After the update is made and I select a new field, I
cannot move to a new record, Why?

Because AfterUpdate is *too late*. The record has already been written to
disk; setting a bound column to Now will cause the BeforeUpdate event to fire
again, then the update to be applied again, then the Afterupdate to fire
AGAIN, then.... loop de loop!

Use the form's BeforeUpdate instead.

John W. Vinson [MVP]