Close query without saving layout change

[GaelicFatboy]

Chaps and Chapesses,

I have a form with a child that holds a query and for 99.9% of the time remains locked as it's for viewing data only. However, if the user wishes to make a change then they need to press an unlock button first then make the changes.

The problem I have is when closing the form; if this child's query has been unlocked I'm getting a message asking do I wish to save the changes to the layout of the child's query. The answer will always be "No".

I've added the following line of code to all sorts of procedures with no success.

DoCmd.Close acQuery, "LinkTableManager_Frmqry", acSaveNo

Any ideas on how to stop the message appearing when the form is closed.

Cheers

D

 

[JHB]

If the query is embedded in the form isn't it the form you should close without saving?

 

[GaelicFatboy]

Sorry, I'm probably not making myself clear the Child is a subform of the main form and I do have a line of code to close the form with save as set to "No", but it still prompts me to save the layout changes when I close.

Cheers

D

 

[JHB]

If you still not have got it, then post the database with some sample data.