Over the last few years I have created an internal system that uses excel forms to retrieve data from a access database. It records sales/deliveries/payments. One machine on a network that is far from the server is slow to retrieve pending orders to its listbox.

Please Login or Register  to view this content.
I have improved the retrieval time by removing a recordset filter method from the form initialize event and putting it in a listbox change event.

All record data remains in the tblPendingOrders table.

Is there a way where I could pre - filter the data before retrieval from tblPendingOrders - or - create a second table that only displays the prefiltered data required.

Any suggestions appreciated