After Update not writing information to table

[Iamrickdeans]

Hi everyone,

I have an after update event that populates, Date, Time and User into corresponding fields when the record status changes to closed.

However... Whilst the information is recorded on the form it does not record to the underlying table is there any reason for this, or anything that I am not doing correctly?

Regards

Richard

 

[Galaxiom]

You have not really given us anything to go on.

Are these textboxes on the form bound to the form's recordsource?

 

[gemma-the-husky]

using the after update event is likely to be actually changing the data for the NEXT record, rather than the current record. The afterupdate occurs AFTER the record is saved.


I would check the time stamps/data to see if that is the case

it's confusing really, without checking it, as if the next record hasn't loaded, then you will be redirtying the current record - and it is tricky to think how you ever get out of this cycle???

Add record selectors to the form, and you will be able to see what is happening

Anyway, you generally need to be using the beforeupdate event, I think, to make final changes BEFORE the record is saved.

I would check the time stamps/data in the table to see if the update info is being saved against a different record to the one you expected.