Cancel button

[Niniel]

Hello,

I am looking to put a cancel button on my data entry form. When the user's
already typed something, I can Undo and Close, but if they decide to cancel
before they even enter data, I get an error message that Undo cannot be
performed.

I guess I need to check if the form has changed already or not and then
either do a straight close, or an Undo and Close.

Can I get some help with that please?

Thank you.

 

[S Isfeld]

Hello,

I am looking to put a cancel button on my data entry form. When the user's
already typed something, I can Undo and Close, but if they decide to cancel
before they even enter data, I get an error message that Undo cannot be
performed.

I guess I need to check if the form has changed already or not and then
either do a straight close, or an Undo and Close.

Can I get some help with that please?

Thank you.

Just check if the dirty flag is set to true for the form

if Me.Dirty = True then
Me.Undo
end if

Me.Close

 

[Niniel]

Thank you.

Me.Close didn't work, so I'm using DoCmd.Close instead.

 

[yanz]

Hi, I'm beginner in access.
I've got the same problem which is having message about Undo cannot be
performed and if I do not use the undo button,when I close the form without
finishing their form, it's been saved also.
Where did I need to put this:

if Me.Dirty = True then
Me.Undo
end if

Me.Close

Thanks.