Closing a Bound Form without Saving to the underlying table?

I

Iain

Is it possible to close a form with fields bound to a table, without saving
any data that is in the fields on the Form?

I've tried using acSaveNo but the data still gets saved.
 
A

Arvin Meyer [MVP]

You can undo the form. Code is:

Me.Undo
Me.Undo

I do it twice to make sure that, it is done (and not being confused with
undoing the last control)

You will still lose any autonumber that has been used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing fields from a form's underlying table 11
Access MS Access Listbox not saving to bound field 0
how do you close a data entry form without saving record 2
Windows Vista DoCmd. Close ac Form command 3
Combo Box text display question 4
how do I get the form's table to update with a button? 7
Format Table or Form ? 5
acnewrec? 1

Top