We have a form with a combo box. There is a subform (in datasheet view) that is driven by this combo box. Whenever a name is selected in the combo box, a list of the relating records pops up in the subform. We make changes to the records in the subform. When we make these changes, is there a way to make the Audit Trail work?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Audit Trail
- Thread starter Chris75
- Start date
I'm not sure what you mean by "the" audit trail. If you want to create an audit trail, add the fields that compose the audit trail to the table that underlies your subform. Add controls for those fields to the subform. Then, in the BeforeUpdate event procedure of the subform, populate those fields. For example, if you add a LastUpdated field and a txtLastUpdated control, your Form_BeforeUpdate event procedure might have:
Me!txtLastUpdated = Now()
Rick Sprague
Me!txtLastUpdated = Now()
Rick Sprague
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question