Close Form Without save design changes

[Jose Perdigao]

When I open a specific form, I have an event that change the control captions
name.
When I close this form I would like to suppress the message:
Do you want to save changes to the design of form "FORM1"?
When I close via CLOSE BUTTON" upper right. Always shows this message.

I don't want to save and I don't want to receive this message.
What can I do?

I can do this via button, but if i close from the "CLOSE BUTTON" upper
right, the message comes again.

Any help?

Thanks
jxp

 

[Maurice]

What's the code that makes the change. I change captions frequently via code
but that doesn't let the form ask me if i want to save the changes. So I
guess it's the way it's changed that must make a difference and we can only
tell something useful about that if you tell us what you do...

 

[tina]

you can get rid of the CLOSE BUTTON (x button) in the right corner of the
form's title bar, forcing the user to close the form from the command
button. in the form's Design view, set the ControlBox and CloseButton
properties to No. just make sure the "Close" command button is present and
working correctly, before you change the property settings.

hth

 

[Van T. Dinh]

Try:

* Open your Form in Design View then open the Properties window of the Form.
* In the "Other" tab, set the Property "Allow Design Changes" to "Design
View Only"
* Save and close the Form.

Now try your form in Normal View ...

 

[Klatuu]

Ver simple, just use the options of the Close method

Docmd.Close asForm, Me.Name, acSaveNo

 

[boblarson]

small typo:

Docmd.Close asForm, Me.Name, acSaveNo

SHOULD be:

Docmd.Close acForm, Me.Name, acSaveNo
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

 

[Klatuu]

thanks or the catch