Member Avatar for 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!!!

  • 3 Contributors
  • 3 Replies
  • 102 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by akhileshbc
Member Avatar for 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.

Member Avatar for 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..

Member Avatar for 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...

Edited by akhileshbc because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.