I have an Access database with the front-end running locally and the back-end on the server. My main form has several combo boxes, each of which is populated through a single table. This table is linked to a separate Access database (called TSCS.accdb), which is held locally. Pretty much everything works fine (including distributing updates etc.).
The problem is, that the moment I select an item from a combo box, it opens up TSCS.accdb and populates the list (quite correctly). However, this action also keeps TSCS.accdb open, even when I move to another record, and change fields. I understand why this happens, but in this specific instance, I need it to close connection as soon as the combo box loses focus.
Is there any way that I can close this connection without closing the form?