I am looking after a database that has a small number of users. The users are getting the error "The form was changed by another user since you opened it", which is strange because they are not making changes to any of the forms. I don't know why this is happening.
I tried setting the code that opens the form to open a new instance for each user - eg
Public frm as form (declared in separate module)
set frm = new Form_Main_menu
This opens each form as a new instance to avoid the error, BUT this has caused 2 problems:
1. Now it is impossible to refer to the form. The code
Forms("Main_menu").Visible =True causes the error "Access couldn't find a form with that name"
2. A related problem is that when other forms (with controls that take information from the "Main_menu" form) are opened, the same error appears.
So the question is: how can I allow the users to open the Main_menu form without errors? I would prefer to do this without having to worry about instances, just find a way avoid the error "another users has changed the form since you opened it..." If this is not possible then how can I do it using instances, in a way that lets the code, and controls on other forms, refer to the form "Main_menu" by name.