Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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