testing if a form has been edited?

[tania20]

Hi, does anyone know how to check if a form has been edited?

Cheers

tania

 

[Remou]

There is a Dirty property, is that what you mean?

 

[tania20]

thats it!
im guessing then it is something like

If Me.Dirty = True then
...

end if

cheers

 

[Remou]

You don't need '=True'

 

[tania20]

mmm, its not really working how i expected. On my form unload i want to check if there have been any edits, if there has i want to display a custom save msgbox.if they choose no here then the edits will be discarded.

If Me.Dirty then

If MsgBox(strmsg, vbQuestion + vbYesNo, "Save Record?") = vbYes Then
...code here...
Else
DoCmd.RunCommand acCmdUndo
End if

yet me.dirty is returning false even when I have edited data?

 

[Tarnish]

HI tania:

Put your code in the 'before update' event of the form. By the time the form unload event runs, the edits have already been saved (which is why the Me.dirty is returning false).

Hope that helps,
T

 

[Tarnish]

PS: You'll need another 'End If' (no parens) at the end of your code...
T

 

[tania20]

thanks works with code in before update