Me.dirty doesn't work

[David Howlett]

I included the code:

if Me.dirty then
<code>
endif

if the Close event of my form. It returns false all the time.

 

[Rick Brandt]

I included the code:

if Me.dirty then
<code>
endif

if the Close event of my form. It returns false all the time.

Without testing it I would guess that the form is updated before the close
event and therefore will never be dirty at that time.

 

[Sandra Daigle]

Hi David,

If you check the order of events on forms you will find that the UpdateEvent
occurs before the Close event so any updates will have already been applied
when the Close event fires.