Topic: vb..object closed!

[davypipes]

am getting this error everytime i cancell any update i do in my form:

error "3704"
"operation not allowed when object is closed"

heres the code snippet:

Private Sub cmdcancel_Click()
'dataenv is my dataenvironment connected to a access dbse  
With dataenv.rssale
.CancelUpdate

End With
End Sub
any ideas on wats wrong?

and another thing...emmm..is it a good idea to trap error numbers and use them for validation? eg:
     errornum=Err.number
     if errornum=1234567 then
     msgbox(please enter all required values)
     end if

will a different number be generated on a different machine?hence not doing the validation ?

[Simon]

Sorry for the delay, Davy.  Hopefully someone will be able to help you with this soon.

[davypipes]

oooh thanks simon...its wasnt that argent!! anyway i was able(with my friends help!) to get the root of the problem!! u see i had called the wrong
table ie:
With dataenv.rssale
 'should have benn..
With dataenv.rsprofiles
...so theres the bugga, but about the error number...well i still havenmt gotten any info on the adv/disdvantages of using them.