Closing a Bound Form without Saving to the underlying table?

  • Thread starter Thread starter Iain
  • Start date Start date
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.
 
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

Access MS Access Listbox not saving to bound field 0
Access Automatically Send a notification email once a record is added 0
Windows Vista DoCmd. Close ac Form command 3
Referencing fields from a form's underlying table 11
how do you close a data entry form without saving record 2
acnewrec? 1
Yes/No field custom format text color 1
populate form with a recordset 3

Back
Top