After Hours



Regarding article: A simple solution for tracking changes to Access data

By ithopkinton ·
Tags: Off Topic
I came across this article and it is perfect for my needs. However I have tabbed subforms that when I put the before update event in the subform properties I get a run-time error 13 type mismatch.

I am just starting to learn VBA so I am kind of stuck.

In the before update event of the subform this is what I have

Private Sub Form_BeforeUpdate(Cancel As Integer)
Call AuditTrail(Me, Counter)
End Sub

Counter is the primary key in the subtable that is an autonumber. The form itself links to the parent form by field called "ProjectNumber" which is the primary key in the parent table. (Which is how the tables are set up as well, Parent table PK is Project number, so the parent has a 1 to many relationship with the subtable which is why we created the counter field to have a PK in the subtables.

Any ideas would be greatly appreciated.

Orig article here:

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums