Change the code to the below:
Private Sub ReqLists()
Me.lstSelectedFleets.Requery
Me.lstSelectedPositions.Requery
Me.lstSelectedFleets.Value = Null
Me.lstSelectedPositions.Value = Null
End Sub
Maybe it's not so much a connection question but more a time issue, how deep in the disk root are the databases located?
But you will confirm or disprove it by having both the BE and FE databases on the same server.
Your problem is that the data get updated when the reports run and that when you move out (event lost focus) of the list box a refresh macro run.
All "code" in your database are build with macros. I always use Event Procedure so ...
Is it possible you could post the database with some sample data, zip it because you haven't post 10 post yet. + a description how to reproduce the problem.