Forms and Subforms relationships

[iskender]

Dear Forum members,

I have form with subform inside (datasheet view). Also i have macro which i run in data entry for main form. This is working as follow:

Public Sub Form_BeforeInsert(Cancel As Integer)
Call AuditChanges("PONumberID")
End Sub

and work perfectly to main form. However when I install same event procedure for subform, macro is not working



Please help me
Thank you in advance
Iskender

[orange]

Please show the code for AuditChanges.
Is the AuditChanges taken from Martin Green's site?

[iskender]

Dear Moderator,

Exact - i have picked code from here:

https://www.fontstuff.com/access/acctut21.htm

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

[orange]

iskender,

There is an issue with the audit program from Martin Green. It does not deal with subforms and it identifies the wrong record for Deletes.
See this thread for the dialog with PSSMargaret describing the problems and a solution.

Here is a related thread -similar subject - with some comments that may be helpful.
https://access-programmers.co.uk/for...ighlight=audit

Since you have Acc2016, you may want to review this thread on Macros for an alternate approach. The thread was about use of macros, but I mentioned data macros (starting at post #8). I show a sample of an audit trail using data macros.

Good luck with your project.

[iskender]

Dear Moderator,

I have tried all 3 links you send me but non of them could help me. Send you example of working file (where AuditTrail works for form but not for subform). Can you please help me to define what is wrong with subforms?

Thank you
Iskender

[iskender]

Dear Moderator,

Kind reminder - could you please review attached from my previous post and let me know what I do wrong? Thank you

[orange]

See this link for the latest info ---database example and word document description. I'm would have thought that the dialog with PSSMargaret mentioned previously would have highlighted some issues with the audit code from fontstuff.
But, having looked at your database, I see that your relationships are incomplete - not all of your tables are represented; PK's are suspicious. I do not use embedded macros. It is unclear what this database is intended to support. When posting, it is helpful for communication if you supply a description of the business involved to provide context.

Here is another thread where a poster has issues with the same audit code you are working with.

Good luck.