Cancel for Continuous form

J

jonefer

I have a continuous form that displays records like so:

Environment RFC #
======== ====
Production 123456
Testing 123457

It usually checks for how many environments need an RFC number,
so sometimes the form will only display 1 record.

That's why I display it as continuous, so it can look clean for just one
record.

My concern, is that if I update a record and click my cancel button..
which is basically a "me.undo" and a doCmd.Close
the record is STILL written. How do I effectively cancel it without having
to go through a recordset, find it and delete it?
 
P

PC Datasheet

Once you save a record you can not undo it. In a continuous form, a record
that has been changed gets saved when you move to a different record or move
to a control outside the record such as a button at the bottom of the page.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.
 
M

Marshall Barton

PC said:
Once you save a record you can not undo it. In a continuous form, a record
that has been changed gets saved when you move to a different record or move
to a control outside the record such as a button at the bottom of the page.
Click to expand...


An edited record on a continuous (or any view) form IS NOT
saved when the focus is moved to a control in the
header/footer section.

It is important to note that an edited record IS saved when
the focus moves from a main form to a subform and vice
versa.
 
Top