May 30 2012, 06:48 AM
Regarding A2K version:
I've got a bound form/subform and what I want to do is capture certain key variables from both record sources in an audit/historical table via append query if either record source has been updated.
The after update event works for each form individually but if I update variables in the parent form and go to the child form to perform another update, I have two update events and my append query runs twice.
Is there some way to run an after update event only once?
May 30 2012, 09:42 AM
I think the realistic answer is No there isn't any way.
It would be possible by completely rewriting all the audit code to execute using, say. intermediate tables to store current changes and then only writing to the true audit table when the form closed or you moved to a different record. However I don't think it is practical option, starting from a conventional auditing process.
There would be , of course, a real technical problem of recording changes in a single record in such a way that it is clear which main form record and which subform record(s) have been changed.
May 30 2012, 10:22 AM
Thankyou Peter. It looks like I will have to revisit my assumptions as I completely missed the subform record(s) issue.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here