Close form without saving data

G

Guest

Users sometimes leave data in fields and then close the form. this results
in junk records. I have a "Save" button that saves records that they should
use but they 'forget'.

Is there a way to close a form without saving changes to the current record?

Steve
 
G

Guest

Never mind. I found the answer in HELP. all I have to do is set the CANCEL
property of the close button to YES and any record (or patrial record) that
has not been daved by the SAVE button will be discarded when the form closes.
slick

Steve
 
G

Guest

Hi Steve - I had a similar issue and the way you suggest works - however if
the user forgets to use the save button you will junk info they wanted. You
can use a message box to ask if they want to save the info or not and respond
by either cancelling or saving.
 

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

Stopping automatic SAVE on close 1
If I open a form, add a new record, close the form (without saving or changing records) will it stil 1
Access Automatically Send a notification email once a record is added 0
Saving a record 4
Close form without saving changes 3
Need combo box to refresh when moving to new record 2017 1
Record Change Confirmation 8
Validate data then save it 6

Top