-
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