MS Access - Prevent prompt to save form

2019-09-07 06:31发布

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条回答
地球回转人心会变
2楼-- · 2019-09-07 06:44

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.

查看更多
登录 后发表回答