Form Recordset "Object Closed"

[Brian Korenaga]

Brand new to Access and ADP, so forgive me if this is obvious.

Using Access2002, SQL2000 with bound form. I use a SQL stored
procedure to fill a ADODB recordset, then set the ADODB recordset
equal to form recordset. Then delete ADODB recordset.

My problem is that when I try to manipulate the form recordset
(example Form.RecordSet.AddNew), I get a runtime error 3704,
"Operation is not allowed when object is closed". I've tried
Form.RecordSet.Open without any change in the error message.

In a related error, if I create a new ADODB recordset and set the form
recordset equal to the new ADODB recordset. Trying to manipulate
ADODB recordset, I get the same error message.

RecordsetClone doesn't have this problem.

TIA,
Brian

 

[J. Clay]

I am not quite sure why you would be doing things this way. Typically, you
would bind the form to the Stored procedure and set any inputparameters
required by setting the form recordset equal to the stored proceedure. Once
you close the recordset, it is not going to be editable.

J. Clay