Enter date/time into table

  • Thread starter Thread starter MeSteve
  • Start date Start date
M

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?
 
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.
Click to expand...
How is your form navigating to the new record? Does your form have a save
button or a new record button?

Jeanette Cunningham
 
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?
Click to expand...

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]
 
Back
Top