I have a form that has the recordsource set to a query and all the 'text' boxes on the form are 'bound'.
I want to detect when any text box on the form has had data changed. I tried using the 'FormDirty' event. In testing, I am changing the data in one of the text boxes and the 'FormDirty' event fires off. Behind the 'FormDirty' event I have put that would enable a 'save' button.
If me.Dirty then
cmdSaveRec.enabled = true
else
cmdSaveRec.enabled = false
End if
My problem is, which confuses me is that the 'Form Dirty' event is being triggered, however, when this code runs 'me.dirty' is 'FALSE'. How could the form event be triggering the 'dirty' event and then the value of me.dirty be false?
I am thinking that maybe because the form has 'bound' columns the record is being somehow updated so it triggers the event on the change of data but also saves the record changes so somehow the me.dirty is set to false?
I am very confused about how/when all the events happen. I thought this would be an easy task just to determine when any record data on the form has been changed.
Any ideas on what I am doing wrong????
THansk!