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.
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
Bookmarks