Visual InterDev

Lookup Tab (Listbox Properties Dialog Box)

See Also      Tasks

Sets options for the data displayed in the Listbox design-time control's list.

Options

List Source

Choose the type of source you want to use for the list box. If you choose Recordset, the data in the list comes from the recordset selected in the Row source box. If you choose Static list, you enter the values for the list in the table in the Static list section.

Recordset

Row source

Choose the name of a Recordset design-time control on the page. The data in the list comes from this recordset. This property is only available if you choose Recordset for List Source. Sets the RowSource property for the control.

Note   The recordset you choose must have the same Scripting Platform setting as the recordset selected for the Recordset setting on the General tab of the Listbox properties dialog box.

Bound column

Choose the name of a field from the recordset selected in the Row source box. The data stored in the control when you select a value from the list comes from this field. This property is only available if you choose Recordset for List Source. Sets the BoundColumn property for the control.

Note   The field specified by the Bound column setting is typically the foreign key for the recordset specified in the Recordset property setting of the list box control.

The list box displays the set of values from the field specified by the List field setting. When you select one of these values, the corresponding value in the field specified by the Bound column setting is written to the field in the recordset specified by the Field property setting on the General tab of the Listbox properties dialog box.

List field

Choose the name of a field from the recordset selected in the Row source box. The data displayed in the list comes from this field. This property is only available if you choose Recordset for List Source. Sets the ListField property for the control.

Static list

Bound value

Enter a set of values to store in the control. For each selection in the Display column, the corresponding value in the Bound value column is stored in the recordset field determined by the field property setting on the General tab of the Listbox properties dialog box.

Display

Enter a list of values to display in the list box list.