I'm using textboxes linked to a data control in VB6. The data control is in turn opening a Dynaset from an Access database. My problem is this:

I want to add a date field in the database to mark the last time each record was modified.

The update to the datacontrol.recordset is done automatically when a movenext or moveprevious is executed (as the user steps through the recordset for example). Since there's no update event generated by a data control (I think), I don't know how to detect when I should write the date to the database.

Any ideas?

- john