Hi guys!
I have a problem (surpise surpise!)
I have a form that loads up data from a Access 97 table.
There are 40 fields with about 2000 records.
While loading I populate about 20 combo boxes.
To populate I'm using a separate adodc component attached to these datacombo boxes. These adodcs provide the row source data, while all my components are bound to one adodc component.
The PROBLEM is that it takes about 20 sec to load the form!
I do hear that these adodc componets are slow and that most serious programmers use pure code to populate normal combo boxes.
Is this right?
If so can some body show me in code how to bind a combo box to a data ource and populate the row source with another.
Other wise is there a better faster way to load my form...I have no choice with the number of combo boxes.
Here is a tpyical example
Dim strSQL As String
strSQL = "SELECT * FROM [ListOrganism] Order by Organism"
With AdOrg2
.ConnectionString = cndata
.CommandType = adCmdText
.EOFAction = adDoMoveLast
.RecordSource = strSQL
.Refresh
End With
My connection string is as follows:
With cndata
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=false;Data Source=" & strDataLoc
.ConnectionTimeout = 10
.Open
End With
I use the same connection string for all my recordsets/adodc components
Any suggestions
Regard
Gerard
