DOCUMENT:Q189682  11-AUG-1998  [vbwin]
TITLE   :HOWTO: Bind a DataList or DataCombo to a Recordset at Run-Time
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:
OPER/SYS:WINDOWS
KEYWORDS:

======================================================================
---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual Basic Professional and Enterprise Editions for
   Windows, version 6.0
---------------------------------------------------------------------

SUMMARY
=======

When binding a DataList or a DataCombo control to an ADO recordset at run
time, follow the steps below:

   DataCombo1.DataField = "DestinationBoundField"
   DataCombo1.BoundColumn = "SourceBoundField"
   DataCombo1.ListField = "SourceDisplayField"
   Set DataCombo1.RowSource = rsSourceRecordset
   Set DataCombo1.DataSource = rsDestinationRecordset

For example, you may want to maintain an EmployeeID field in an Orders
table; however, you would want to allow the user to select the appropriate
employee information by the employee's name, rather than by the EmployeeID
field.

In this case, the destination for the selection from the combo box is the
EmployeeID field in the Orders recordset. But the source for this
information is the recordset containing information from the Employees
table.

The ListField property should be set to the field whose information you
want to display; while the BoundColumn property should be set to the field
whose information you want to bind to the destination recordset. In this
case, the ListField would be EmployeeName and the BoundColumn would be
EmployeeID.

Additional query words: DataList DataCombo kbdse kbDSupport kbVBp
kbvbp600 kbDataBinding
======================================================================
Platform          : WINDOWS
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1998.