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 &
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
