Error!!!

[Israelsimba]

My subscription system is now running though with errors here and there.the error that concerns me a lot is a runtime error that says
multiple steps generated an error check value status
and points to this code....

r.Fields("companyphone") = txtcphone.Text
r.Fields("companywebsite") = txtcwebsite.Text

and this code is in my save button. at times the error doesnt show but at times it pops up when a user is testing...
how best can i trap such an error because i know there must be a way which i dont know.
thank you in advance!!!

[jireh]

check the fields if it allows null value. if not then put a trappings to force the user to enter a value on the field.

[Israelsimba]

it doesnt enforce any fields in the database..but i have enforced at form level..ie a person cannot save without entering all the required fields on the form. this error pops up a any time but not always..

[akhileshbc]

on error goto Er

      r.Fields("companyphone") = txtcphone.Text
  
      r.Fields("companywebsite") = txtcwebsite.Text
exit sub
Er:
msgbox "Error occured"

Please post your entire code inside save button...