
Changing the source on an ADO recordset bound to controls
Check Recordset.ActiveConnection property after you close recordset. It must
be Nothing. Otherwise recordset didn't close because something still
references it (boundcontrol).
Quote:
> I have written a class that acts as a datasource for the boundcontrols on
my
> form but I need to change the source for the recordset in the class. If I
> close the recordset, change the source and try to reopen it, I get an
error
> saying that it is already open. How can I change the source of the
> recordset?
> David Francis