I have two buttons on a form, Save and Close. The Save button will close the form and save any changes. I don't the Close button to do anything but close the form, but it keeps saving changes just like the Save button. What do I need to do?

And yes I've tried:
DoCmd.Close, "", acSaveNo ... it doesn't work.

One option is to open the form UNbound to begin with. If you close the form, then nothing is saved anyway. If you want to save the data, THEN you write code in your save button to purposely save the data and close the form.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

That works if nothing has been changed, but I don't want to save ANY changes that someone may have made to the data while viewing the record.

Is there some object or function that I can disable?

- cq

No, if you open a form UNbound, nothing will be changed if you just close the form. Not even if you typed something in every field.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Ok, the light bulb is not coming on here. How do I open the form UNbound

- cq

How about just changing the properties of the form?

On the tab for Data:
Change "Allow Edits" from "Yes" to "No"

That defeats the purpose of the form. The "Close" button is suppose the close the form, nothing else. Even if someone mistakenly fat fingers a field or hits the scroll button on their mouse. If they don't click the "Save" button the record should not change.

Is there some default feature in Access that is forcing the record to be saved if any edit is made?

-c

The way Access works is that if you open a BOUND form and you make any changes to any field in the data, as soon as you leave the record (either by scrolling to the next one or closing the form), the record is saved automatically.

Here are two ways to avoid it. You can either open the form UNbound and then populate the data from your table (in which case just closing the form will not save data, you have to write code to save data); or you can open the form BOUND like you're doing, but on your ON CLICK event of the CLOSE button, you can place a

Me.Undo

command just prior to closing the form. That should undo the typing of the record.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I knew it could be done. Thank you, that is what I was looking for!

:)