Hello,

My code below generates this error. "Object was open"

I dont understand this error. I am sure that checking the state and closing it if the state =1 should close the command.

Furthermore. I removed the state check code and proceeded to do this:
de.rscmdRetSite.close

I then received a message that my command is closed.
After which I tried to execute the select statemtent only to receive the
"Object was open" error again..



If de.rscmdRetSiteDet.State = 1 Then
de.rscmdRetSiteDet.Close
End If


de.rscmdRetSiteDet.Open "SELECT * FROM Site" & _
" WHERE customerID= '" & customerid & "'"

Any help would be appreciated.

Thank You,

Alvin