How do I modify Auditing Code to deal with Sub-Forms and Data Relationships?

add another condition
Code: 
                If ctl.Tag = "Audit" Or ctl.Tag = "ListAudit" Then
                    If ((Nz(ctl.value) <> Nz(ctl.OldValue)) Or ctl.Tag = "ListAudit") And Nz(ctl.OldValue, "") <> "" Then
 
You must log in or register to reply here.

Similar threads

N
Solved How to scan a barcode from a parent form and update the child/subform in MS access
Replies
4
Views
531
Uncle Gizmo
Uncle Gizmo
F
Solved Form with subform filtered by two cascading combo boxes and a checkbox
2
Replies
26
Views
1,606
Faoineag
F
R
How do I save the layout of a subform after modifying it on the main form's on open event?
Replies
12
Views
936
RickSanchez
R
adhoustonj
How many db's do I really have open?
Replies
4
Views
869
adhoustonj
adhoustonj
I
Solved Confused on what Form event(s) to use that display form with only statis text before VBA code executes
Replies
13
Views
955
isaksp00
I

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom