ListRowSource Property

                  Applies To

Specifies the data source for a list box or combo box. This property applies only to list boxes and combo boxes, and it must be set before the ListBoundField or ListDisplayField property is set. Read/write String.

Remarks

This property is used with the ListBoundField property and the ListDisplayField property to control how data is displayed in a list box or combo box. For example, consider a list box which displays product names in a section called Order Details. The recordset behind the Order Details section includes a field named ProductID which is the product for a given Order Detail record. But instead of displaying ProductID in a textbox, the page author wants to display product names in a dropdown list box. The list box can be filled with a recordset definition named Products which contains fields called ProdID and ProductName from the Product table. The properties of this list box element would be set as shown in the following table.

Property Value
ListRowSource Products
ListBoundField Prod ID
ListDisplayField Product Name
ControlSource Product ID