Saving to two ADODC's

[Vaisey]

My saving to two adodc's at the same time comes up with an error.
Here is the code:
Private Sub Image8_Click()
txt_memberID2 = txt_memberID
txt_handicaps2 = txt_handicaps
txt_handicaps3 = txt_handicaps
Adodc1.Recordset.Update
Adodc1.Recordset.Requery
Adodc2.Recordset.Update
Adodc2.Recordset.Requery
Unload Me
frm_members.Show
End Sub

[Doogle]

What error is being reported and on which line. The code you've given doesn't give us any idea of the current state of the RecordSets (ie are they populated and Open?) perhaps we need to see a little more code.