stickleprojects
Level: Moderator
Registered: 09-09-2002
Posts: 1060
|
Re: Error on my codes
you have declared a variable called "rs" somewhere in your code.
prior to the statement you have illustrated, the "rs" is already being "opened".
I suggest you look for "rs.open" in your code and make sure it does not happen prior to this line of text.
to stop the error occuring, do the following:
if not (rs is nothing) then
if rs.state = adStateopen then rs.close
set rs = nothing
end if
set rs = new recordset
rs.open........
|
hope this helps
____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)
|
