I got it, thanks for all your help...
Jim
>>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.
Thanks
Jim