Lookup Tab (OptionGroup Properties Dialog Box)

      

Sets options for the data displayed in the OptionGroup design-time control.

Options

List Source

Choose the type of source you want to use for the option group. If you choose Recordset, the data in the option group comes from the recordset selected in the Row source box. If you choose Static list, you enter the values for the option group 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 option group 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 property setting on the General tab of the OptionGroup 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 option group 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 option group control.

The option group 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 OptionGroup properties dialog box.

List field

Choose the name of a field from the recordset selected in the Row source box. The text displayed next to the option buttons in the option group 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 OptionGroup control properties dialog box.

Display

Enter a list of values to display in the option group.