Suppress 'Save changes to layout of query...'?

[DFS]

I'm using a query as the SourceObject for a subform. When I change any of
the column widths and try to close the form I'm prompted to save changes to
the layout.

Anyone know how to suppress this prompt?

I tried SetWarnings False. Didn't work.

I tried saving the query (DoCmd.Save acQuery, ... ) but Access reports that
it's not open.

I tried DoCmd.RunCommand (acCmdSave). Didn't work.

I tried DoCmd.RunCommand (acCmdSaveLayout). Didn't work (says 'SaveLayout
is not available now')
Any ideas?

Thanks

[DFS]

Never mind. Figured it out.

I had to SetWarnings False when opening the form, then SetWarnings True when
closing it.

(and what's actually safer is to SetWarnings when activating/deactivating
the particular form - from which no data can be deleted - in case someone
wants to use other parts of the system from which they can delete data).

DFS wrote:

I'm using a query as the SourceObject for a subform. When I change
any of the column widths and try to close the form I'm prompted to
save changes to the layout.

Anyone know how to suppress this prompt?

I tried SetWarnings False. Didn't work.

I tried saving the query (DoCmd.Save acQuery, ... ) but Access
reports that it's not open.

I tried DoCmd.RunCommand (acCmdSave). Didn't work.

I tried DoCmd.RunCommand (acCmdSaveLayout). Didn't work (says
'SaveLayout is not available now')
Any ideas?

Thanks