Access Audit - Looking at the wrong form
Posted on 2014-02-25
I am using a well know "audit" for monitoring changes to my database.
It works fine until I start using sub forms.
For example, let's say I have a form called frmMain which holds a form called frmSub
Specifically, the audit has the line;
For Each ctl In Screen.ActiveForm.Controls
Unfortunately, my "active" form is frmMain but I want the audit on frmSub.
I am not sure when my active form is frmMain - the changes took place in frmSub.
As I see it I need to change my audit code to look at frmSub instead of frmMain.
How do I do this?