MS Access - Prevent prompt to save form

问题:

Sometimes when I've made changes to the form via VBA (change in record source, control source, making controls visible or not, etc.) the user will be prompted to save the form when closing it.

Is there any way to avoid this or prevent the prompt?

回答1:

Im posting in the answer section because I'm unable to post under comments, I'm Relatively new to this site.

Anyways, are you making the changes while other users may be using the form at the same time? That's the only thing that would make sense to me is that a user is in the form when you are making your changes which it then asks them to save the changes to the form, as it would be different from the time they first entered into the form.