Unable to Bind to Field or DataMember

Hi,
I have an issue with the reuse of a recordset object.

Basically I have a recordset which I assign the results of a query to. If the user clicks on another tab on the form the recordset is set to Nothing. To my knowledge this is perfectly acceptable.

When I reassign the recordset to the results of another query, the first record is read correctly and the relevant controls on the the tab are populate. However when I try to move to the next record and assign control.datasource, control.datamember etc I get the following:

"Unable to Bind to Field or DataMember"

The reasons provided by documentation is not of any value.


Thanks in advance.

Lenin

I've gotten that error when I tried to bind a textbox to an ADO data control, and the textbox had a column name that was not part of the recordset, so naturally it didn't work.

I doubt this solves your problem, but it might give you a place to start....

Thanks for the reply, but I have checked all the normal probable reasons.

Lenin