Discard form design changes on normal close (unhide columns counts as design change) (1 Viewer)

GK in the UK

Registered User.
Local time
Today, 12:29
Joined
Dec 20, 2017
Messages
274
I have a sub form in a tab control which is a datasheet. The column filters are all available. By default there are some hidden columns but they can be unhidden which is ok. But on close of the main form, using the X, Access asks if I want to save the changes.

How do I stop this message and close the form without design changes?
 

June7

AWF VIP
Local time
Today, 03:29
Joined
Mar 9, 2014
Messages
5,479
Don't allow users to close form with the X button nor right click menu. Use a custom button with code:

DoCmd.Close , , acSaveNo
 

Users who are viewing this thread

Top Bottom