Does Unbound Form's Dirty Property Property Work?

[Mike Thomas]

In Access 2000 I have an unbound form. If all of the data validation checks
are OK, I'll update the underlying table. Problem is that the form's dirty
property does not seem to get updated when the text boxes are unbound.
Apparently, the property is bound to the form's recordset , if there is one,
rather than to its controls.

Is there any way to get this property to work on an unbound form?

Thanks
Mike Thomas

 

[Ken Snell [MVP]]

If the form is unbound, the Dirty event does not occur.

 

[Brendan Reynolds]

You'll need to implement it yourself. One way is to store the original
values when you load the record, and compare the controls against the
original values to determine whether the data is 'dirty'. A
user-defined-type or a class, with an element or property, respectively, for
each field, works well for this.

 

[Mike Thomas]

Thanks Brendan,

Yep, it sounds like real 'man's' programming.

Many thanks
Mike