Home All Groups Group Topic Archive Search About

Checking Fields In Unbound Form

Author
8 Aug 2006 6:00 PM
MARCOC
What is the easiest way to check if any data has been changed by the user on
my unbound form.  I have 12 text boxes and 2 combo boxes on the unbound form.

Thanks,

Author
8 Aug 2006 6:56 PM
GhostInAK
Hello MARCOC,

I accomplish this by subclassing the Textbox and other controls and adding
a .Dirty proeprty.  I set .Dirty = True when a value changes.. I also change
the background color to a different color (usually a lemony yellow).  Then
I can loop over all the controls and check the Dirty property.

-Boo

Show quoteHide quote
> What is the easiest way to check if any data has been changed by the
> user on my unbound form.  I have 12 text boxes and 2 combo boxes on
> the unbound form.
>
> Thanks,
>