Updating Bound Controls from a List or Combo Box

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: