Cancel button on data entry form

J

Jovalle

Guest

• Apr 11, 2000

• #1

I added Cancel button using Undo command on data entry form but getting an error message ("undo action isn't available now"). How do I fix this problem?

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Yesterday, 20:41

Joined

Feb 19, 2002

Messages

48,208

• Apr 11, 2000

• #2

Undo only works on a bound form and I believe it only works BEFORE the record is saved.

 

S

S

Registered User.

Local time

Today, 02:41

Joined

Feb 17, 2000

Messages

33

• Apr 12, 2000

• #3

Try to use the Begintrans, Committrans and Rollback function to undo operation even after hundreds raws of commands or records; I found them very useful.
Hope this helps you, S.

 

R. Hicks

AWF VIP

Local time

Yesterday, 19:41

Joined

Dec 23, 1999

Messages

619

• Apr 13, 2000

• #4

Pat is correct, to my knowledge, you must do this before the record is actually saved. But it is very simple. Using a cmdButton named cmdCancel, here is all it takes:

Private Sub cmdCancel_Click()
Me.Undo
End Sub

Now if the record has been saved, you will need different code to delete record.

Good Luck,
RDH

[This message has been edited by R. Hicks (edited 04-12-2000).]