Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Aug 6, 1997

Updating Bound Controls from a List or Combo Box

When you want your bound controls to be updated in reaction to a 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 the key is presented in the list part of your DBCombo/List. All bound controls are updated automatically. You need to set only the RowSource and the ListField properties of the bound combo/list to achieve this behavior. It saves a lot of trouble converting text strings or other data-type conversions.

Peter Klein
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date