469,610 Members | 1,554 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Validating data on a subform



I have a subform with a header, detail and form footer.
The form Header contains labels identifying the fields in the detail
The Detail section contains 10 data fields (text boxes, combo boxes, and
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 ***
Jan 25 '08 #1
0 1087

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Neil Ginsberg | last post: by
3 posts views Thread by Nicolae Fieraru | last post: by
reply views Thread by Gary Shell | last post: by
8 posts views Thread by Martin | last post: by
1 post views Thread by kenduron | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.