Detecting Data Changes with Form Events

Question

If you read my recent recent questions, you probably realized that I am not an access developer ... Most of my background is in VB, where I have been diligently avoiding related controls.

Now I work in Access 2007. I have a form based on a table (well, a query with one table) and a subformation on it based on a one-to-many child table. I want to detect user-made changes to data in any of these forms so that I can update the date stamp in the parent table. The actual date field is not displayed to the user (at least not here).

What would be the appropriate event to capture the fact that the change was made? How do I make the actual change (right in form.Recordset! DateField | with a hidden linked text field in some other way)?

Answer 1

You will have to look for the afterupdate event that fires when the updated content of the associated control is updated in the base record set.

In this case, you will need to write the necessary command to update the date field. There is no need to attach it to any form control if the field is in the recordset!

Answer 2

, , . afterupdate ( ). , , , , .