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: http://articles.techrepublic.com.com/5100-10877_11-6166807.html