CODEWITHSUNDEEP
ms-accessms-access-2010
Ben
Ben

Reputation: 893

Stop Subform Requery with Multiple Users in Access 2010

I have a very simple form with a combo box that is populated by a query. A user selects the class for which they want to enter data from the combo box and the records (passing the selection from the combo box to another query) for that class are loaded into a subform.

However, when multiple users are accessing the database and another teacher selects another class from the dropdown and starts entering data, the subform for the first teacher requeries and brings up the class selected by the other teacher.

How do I avoid this?

I have split the database into frontend and backend.

Upvotes: 0

Views: 120

Answers (1)

E Mett
E Mett

Reputation: 2302

It would seem that the combobox for selecting the class is bound to a field in a table. That is why it is updating for one user when another user makes a selection.

You should make this combobox unbound (=clear the ControlSource property).

It is not clear to me if you are already doing this, but the correct way of filtering by a field (class in your case) is to set LinkMasterFields (of the subform control) to the name of your combox control and LinkChildFields to the class field in the the underlying recordset of the the subform.

Upvotes: 3

Related Questions