How to Populate a List or Combo Box with Recordset Data (182061)

MORE INFORMATION

The following files are available for download from the Microsoft Download Center:


DaoDDX.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

This sample contains two DDX functions DDX_BindTextFieldListBoxToColumn() and DDX_BindTextFieldComboBoxToColumn() to link a particular column from a recordset to a list or combo box. These functions take the following parameters:

• A CDataExchange object
• The resource ID of the control to bind to
• The name of the column to bind to
• A CDaoRecordset object to use to retrieve the information.

These functions also take the following two optional parameters (both of which default to false):

• Whether or not to update the column when saving
• Whether or not to allow repeated values in the control

When viewing records, these functions first save the current position in the recordset passed in. This position is treated as the current value of the current record, and is selected when the population is complete. Then the function iterates through all the records in the recordset, either adding the current value to the control, or rejecting the current value if it cannot be converted to a string or it is a duplicate value and duplicate values are not being accepted. The function finishes by restoring the original position of the recordset and then selecting that entry.

When saving, if the optional parameter to update the column is set, the function takes the current record, and updates the field in the column passed in with the currently selected item (or the modified text in a combo box situation). This method would be used in tables where the choices being given are not a foreign key. In the foreign key situation, which is the method used in the example, a second DDX function would be used to tie the selected value for that particular control to a field in the result set given.

The function CDaoDDXView::PositionRecordsets() moves through the foreign recordsets, positioning each on the record denoted by the key value in the CDaoDDXView::m_pEnrollmentSet object. This allows the proper item to be selected in each of the controls, because the selection is based on the current record.