Dirty event

[poporacer]

From my understanding the OnDirty event is only for forms with bound fields. I have a form with several unbound textboxes for data entry. What I would like to do is to find out if any of the textboxes have been altered, if so, then save the data....any suggestions?

 

[ajetrumpet]

On dirty applies only to bound objects, like controls.

Your textboxes will be ignored with the on Dirty property. what I would do is record the data when the form is opened, and then on the close of the form, check to see if the data is different in the controls. if so, save the form with docmd.save acform, me.name

 

[missinglinq]

Unbound controls will be empty when a form opens, will it not?

 

[gemma-the-husky]

when you say, save the data, i take it you mean insert it into a table

therefore you need a button to do this, and in that you need to generate a sql insert or update statement. at this point you can examine your text boxes, and make sure they are populated appropriately.

 

[ajetrumpet]

Unbound controls will be empty when a form opens, will it not?

good point...