When you want your bound controls to be updated in reaction toa user click in a list box or combobox, add this code to the click-event(or double-click event) of the list or combo control:

 Data1.Recordset.Bookmark = _        DBCombo1.SelectedItem        

As a result, your current record is now the record of which thekey is presented in the list part of your DBCombo/List. All boundcontrols are updated automatically. You need to set only the RowSourceand the ListField properties of the bound combo/list to achievethis behavior. It saves a lot of trouble converting text stringsor other data-type conversions.