dp said:
Hi guys I have a strange problem...I have a field thats source is a
combo box column field =[CustomerID].[column](6). It does display,
however when the form is loaded it takes 10 seconds while it
"calculates..." .
Does anybody know a solution for this problem?
Are there a *lot* of customers to be listed in the combo box, or does
the combo box's rowsource query take a long time to run? If this is the
problem, you may be able to either
(a) Use code in the form's Open event to make the combo box finish
loading its rowsource, like this:
Private Sub Form_Open(Cancel As Integer)
Dim lngCount As Long
' Force the combo box to load all rows.
lngCount = Me!cboMyCombo.ListCount
End Sub
or
(b) change the form's recordsource query so that it includes (with
proper joining) the table and field that would be in the combo's 7th
column, then bind your text box directly to that field.
