Access 2007 closing save prompt


Eric Heinold

I have a form that has a sub form. When I close the form, I get a prompt to
save the sub form. I also used to get the prompt to save both the form and
sub form when I closed that form, but added the acSaveNo to the Docmd.Close.
However, that does not stop the prompt for the sub form. Is there a way to
do this?


Eric Heinold



Tas Davies

Hi Eric,

I have this problem as well. From what I can work out it effects datasheet
forms. I have not found a solution apart from changing the subform to a
continuous form. Would like to see Microsoft address this bug, or explain why
it is not a bug.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question