Login | Register   
RSS Feed
Download our iPhone app
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.