Set a RecordSet, then closing it

[bostonfrog]

In the general declaration of my form I

Dim Rs as DAO.Recordset

. In the form's load event, I

Set Rs = Me.RecordSetClone

Why do I get an error message in the form's close event that an object variable is not set, when I put the following code into the form's close event:

Set rs = Nothing
rs.close

Isn't the value of the variable "rs" already stored after the form was loaded into memory? Thanks.
-- Michel

 

[TPetersonFlorida]

you wrote that you do the following on the Close Event of the form:

Set rs = Nothing
rs.close


your problem is you cant set the object to nothing and then call one of its methods. you should call the close method first and then set it to nothing.

hope that helps.

 

[bostonfrog]

Ok, Thanks TPetersonFlorida. I will recode it and hope it solves the problem.
-- Michael