The next step is to create a new instance of the Recordset object in the Initialize event of your UserControl. This is done with the following example of code, which creates a new instance of a record set called rs:

Set rs = New ADODB.Recordset