Validating data on a subform

[RLN]

Hello....

I have a subform with a header, detail and form footer.
The form Header contains labels identifying the fields in the detail
row.
The Detail section contains 10 data fields (text boxes, combo boxes, and
checkboxes.)
The Footer section contains nothing.

This subform is shown in "continuous forms" mode, showing several rows
from table.

When I tab from "Field10 of row 1" to "Field1" of the next row, I need
to check to see if any data in any of the 10 fields was modified. If
data was changed, I need to pop a message asking, "Do you want to accept
the changes or cancel?"
If yes, accept the changes, if not, cancel the changes.

I know there is an "On Dirty" event for each field that is used when the
data changes, but I cannot find a "On Dirty" event when the user tabs
from one row to the next row.

Via VBA, is there a way to loop through the fields in the detail section
(regardless of object type), or do I have to loop through each field in
the detail section and put code in the "On Dirty" event of each
individual data object?

Thank you.

*** Sent via Developersdex http://www.developersdex.com ***