Check if unbound form has changed

  • Thread starter Thread starter Vayse
  • Start date Start date
V

Vayse

Hi
I have an unbound form, and I wish to new if a user has changed any text box
on the form. I would use me.Dirty if it was databound, but that won't work
in this case.
Is there anything else?
Thanks
Vayse
 
You could use the Change event of each individual control and update a dirty
variable, but it's probably easier just to bind it to a (temp) table and
reset the values each time the form is opened.
 
You might try declaring a Public boolean type variable at the module level.
In the OnOpen event of the form, set the value of the variable to false, In
the OnChange event of each control on the form, set a value to the variable
to true. Then just check that variable to determine if the user has changed
anything.
 
Back
Top