Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: VB6
Expertise: beginner
Feb 19, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Dynamically bind a DataList or DataCombo control to an ADO Recordset

When dynamically changing the bound ADORecordset for a DataCombo or DataList control, the order you follow when assigning the properties is important. This is the correct sequence of operations to perform to change the bound recordset for these controls:

' unbind the current sources
Set DataCombo1.DataSource = Nothing
Set DataCombo1.RowSource = Nothing

' set the new binding - start with the string properties
DataCombo1.DataField = "ProductID"    ' the bound field in master table
DataCombo1.BoundColumn = "ID"         ' the bound field in detail table
DataCombo1.ListField = "ProductName"  ' the display field in detail table
Set DataCombo1.RowSource = rsProducts ' the detail table
Set DataCombo1.DataSource = rsOrder   ' the master table

Francesco Balena
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date