I have a form view that is being used to view and update data, after the update, I need a second update event which will submit the data to a different access level ( i.e. from a submit code 1 to submit code 2) So basically after all the fields in the form are updated and the user is satisfied, the record will be updated to the next level, I added a second sqlserver datasource and then added a click even with a sql statement to update only the record in the present page to submit code =2, but the form is not recognizing the second sqldatasource. Can someone please help me with this, thanks...
PAM

I solved this myself by adding the sqldatasource on the page and referring to it in an extra click event in the formview item template, the update event will refer to the unique id as @parameter =formview1.selected value.