Has anyone solved the Audit trail problem with subforms? (1 Viewer)

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 07:06

Joined

Jul 9, 2003

Messages

16,282

• Aug 18, 2016

• #1

Has anyone solved the Audit trail problem with subforms?

I asked the question because back in 2006 I built a database which solved this problem. With a bit of tidying up I think I could make a saleable product out of the code I've got, particularly because it handles the issue of auditing a subform.

Any comment advice criticism welcome...

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 07:06

Joined

Feb 19, 2013

Messages

16,612

• Aug 18, 2016

• #2

I didn't know there was a problem! I don't go back to 2006 so you'll have to refresh my memory...

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Today, 01:06

Joined

Feb 28, 2001

Messages

27,186

• Aug 18, 2016

• #3

The solution to auditing subforms is to define the OnChange or BeforeUpdate event for your subform (as though it were an ordinary form) and call your audit code from there, too.

 

jdraw

Super Moderator

Staff member

Local time

Today, 02:06

Joined

Jan 23, 2006

Messages

15,379

• Aug 18, 2016

• #4

Just curious ---is this post related to this current Audit Trail and subform discussion?

 

RuralGuy

AWF VIP

Local time

Today, 00:06

Joined

Jul 2, 2005

Messages

13,826

• Aug 18, 2016

• #5

I thought Allen Browne's Audit Trail did not have an issue with SubForms. Could be my old brain is slipping a bit.

 

jdraw

Super Moderator

Staff member

Local time

Today, 02:06

Joined

Jan 23, 2006

Messages

15,379

• Aug 18, 2016

• #6

I have seen 3 Audit trail links
-Allen Browne
-Martin Green
-Scottgem

I think the subform issue is specific to Martin Green version.

Perhaps others could comment on usefulness/completeness/ease of use of any /all of the above.