Dynamically populate a drop-down list or list box from an OLEDB data connection

Two custom objects are available in the Object Library palette’s Custom category that you can use to populate two columns with data from an OLEDB data connection. Both the Data Drop-down List object and the Data List Box object will populate two columns with data from an OLEDB data connection.

Note: This is a script-based alternative. You can use dynamic properties to accomplish the same thing. See Dynamically populate a drop-down list or list box.

In the Object Library palette, click the Custom category and drag the appropriate list object onto the page:
- To create a drop-down list, drag the Data Drop-down List object.
- To create a list box, drag the Data List Box object.
Select the object.
Select Window > Script Editor.
In sDataConnectionName = "<value>" , replace value with the data connection name.
In sColHiddenValue = "<value>" , replace value with the hidden value name.
In sColDisplayText = "<value>" , replace value with the display text column name.