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
Dec 4, 2000

Populating Controls From a Recordset


On a form, basing populating controls on a supplied record may lead to error, because a perfect match is needed between the control tags and the field list. Any pre-specified error handler jumps loop, making it hard to resume. A simple way to get around this issue is to use in-line error handling, as illustrated in the following example:
 
Public Sub DataPopulateCustomer(pRst As Recordset)
    Dim ctl As WLText

    'Assume that txt is a control array of type WLText

    On Error Resume Next

    For Each ctl In txt
        ctl.Text = Trim(pRst.Fields(ctl.Tag).Value 
& 
Nazmul Siddiqui
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap