how does one determine if a recordset is opened or closed?
i tried
Code:
if rs.open then
   msgbox "Record is open
else
   msgbox "Record is closed"
end if
it didn't work, and i didn't expect it to work
but i thought i would give it a shot before posting a message on it
thanks