Refreshing rowsources - very s-l-o-w

D

David

I have a form (actually a tab in a tab control) with ten combo boxes. Under certain circumstances, when this tab is selected, I have to refresh all the rowsources. The rowsources are all SQL SELECT statements that retrieve only the columns needed for the combo boxes
I do this in the CHANGE event for the tab control
When the tab is clicked the transition to the tab is ver s-l-o-w and you can see each combo box display one at a time, almost like the old days of 1200bps modems

Is there any way to speed this up? As I understand it, the rowsources have to be refreshed to display a value that was not in the previous rowsource. In other words

Me.cmbX = "MyValue
will display blank in the combo box if MyValue is not in the current rowsource.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top