Simple Auditing Question "SubForm"

[fenhow]

Can anyone tell me by looking at the attached Problem db, why
my audit works in Form "UpdatesA" but in Form "UpdatesB" in which i placed a tab control with the UpdatesA as a subform it does not work.

Can someone please tell me how to fix this problem?

Thanks
Fen

 

[fenhow]

Thanks, i really need the changes to be saved or it defeats the purpose. The funny thing is, when i create a change in A it works, when i open and look at B the changes are there, however i cannot change anything and have it stick in B ?

 

[monkeytunes]

I haven't tested it to try it out, but I'm pretty sure that by making your "Update A" form a subform in "Update B" means you'll have to update all the "MyForm!tbAuditTrail" references to account for the fact that "tbAuditTrail" is now in a subform. Access is looking for "tbAuditTrail" on "MyForm", can't find it, because it's now been placed in "MyForm!Subform". Hope that helps.

 

[fenhow]

What do i update when you say update all the "MyForm" do i update that to "Myform!Subform"?

Thanks

 

[monkeytunes]

In the Modules section is the Audit_Trail code that is being called by the forms. When you open just the form by itself, all the code points to the right path, i.e. "MyForm". When you have your input form in the tab as a subform, the path is now one level deeper - "MyForm" refers to the form with the tab, not your input form (which is now actually a Subform). Does that make sense?