i have an error handler in a btn_Click() sub. this sub calls functions that do all my db work, and these functions reside in separate modules. i do not have error handlers in any of the functions, and let all the errors filiter back to this buttons error handler.
i'm trying to close my recordsets in this err handler, but get a runtime error '3219' not in this context when called. the recordsets variables are declared in another module that contains all of my contants & globals.
this is what i'm attempting:
If Not rsread Is Nothing Then
If rsread.state = adStateOpen Then rsread.Close
it's interesting because i can check the state by calling
which returns a valid response but cannot close it if open
any help would be appreciated