I have written a VBA audit that records the OLDVALUE and NEW VALUE of a field.
It uses Set MyForm = Screen.ActiveForm in order to determine the fields on the screen.
It then loops through the data checking for changes.
I have a sub form too.
However, when I call my AUDIT function from the subform, the AUDIT VBA check the parent form and NOT the subform.
How can I get my VBA to check the subform rather than the parent form.
If this is not clear then I can add the code to the query.