Can anyone help me with this...
I have 2 forms...form1 form2...based on form1 input (ssn) it will either open form2 with a record matching (ssn) or give a custom msgbox, however access2000 also displays after clicking vbok on the custom msgbox...the error is being generated from form2--docmd openform-- my msgbox is triggered at oncurrent event for form2...isnull(ssn) then msgbox....i need a code to ignore access error display and return to form1 ssn.setfocus....
I have 2 forms...form1 form2...based on form1 input (ssn) it will either open form2 with a record matching (ssn) or give a custom msgbox, however access2000 also displays after clicking vbok on the custom msgbox...the error is being generated from form2--docmd openform-- my msgbox is triggered at oncurrent event for form2...isnull(ssn) then msgbox....i need a code to ignore access error display and return to form1 ssn.setfocus....
