Me.dirty doesn't work

D

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.
 
R

Rick Brandt

David Howlett said:
I included the code:

if Me.dirty then
<code>
endif

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

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

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.
 
Top