Sink_or_Swim
New member
- Local time
- Yesterday, 22:49
- Joined
- Aug 14, 2008
- Messages
- 5
I have a split database [backend-frontend]. The backend is on the network and the frontend is local. The db connection is solely DAO.
When I initially launch Access my main form opens quickly and the data is populated also quickly (its a split form) with no delay. I have a cascading combobox box and whenever I select the second combobox (a query is run based on the selection in the first) there is about a 5 second delay before the data is retrieved.
I don't think this is related to the actual speed at which the data is retrieved. This is because I have other cascading comboboxes on the form that are lightning fast but only after that first delay.
My question is why this delay occurs on the first combobox but other comboboxes with unrelated data are lighting fast. I'm using all of the same methods per combobox.
When I initially launch Access my main form opens quickly and the data is populated also quickly (its a split form) with no delay. I have a cascading combobox box and whenever I select the second combobox (a query is run based on the selection in the first) there is about a 5 second delay before the data is retrieved.
I don't think this is related to the actual speed at which the data is retrieved. This is because I have other cascading comboboxes on the form that are lightning fast but only after that first delay.
My question is why this delay occurs on the first combobox but other comboboxes with unrelated data are lighting fast. I'm using all of the same methods per combobox.
Last edited:
