Solved Form Auto Populated field (1 Viewer)

[Teri Bridges]

Hi, I was wondering if I have a field that is auto-populated based on another field entry, can I do an after-update function on the auto-populated field?

I have a review date field and when I select the date, the due date auto-populates adding 4 days to the due date.

I was trying to get a count of days between the due date and todays date. If it is not overdue I would expect a + number, if it is overdue I would expect a - Number.

 

[Gasman]

Easy enough to test, I would have thought?

 

[MajP]

can I do an after-update function on the auto-populated field?

No the controls after update does not fire if the update is done through code.

Changing data in a control by using Visual Basic or a macro containing the SetValue action doesn't trigger these events for the control. However, if you then move to another record or save the record, the form's AfterUpdate event does occur.

Form.AfterUpdate event (Access)

Office VBA reference topic

learn.microsoft.com