>Eric,
>
> I want to create an ActiveX control that will be used on a form that uses ADO and has the following functionality.
>
> 1. Creates a new record.
> 2. Navigates through a recordset.
> 3. Has the ability to delete a record.
> 4. Has the ability to update and cancel records.
>
> I have a bunch of forms where this ActiveX control will be used. So I want to create it generically and pass the current recordset to each of the functions. Is this possible? If so, how?
>
OK in this case, just like I said earlier, Create a public property with a ADODB.Recordset datatype and pass your current recordset to this property.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com