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