Hi again,
Still I don't get the query, which the second combobox is based on, to update correct. I interpret your input as follows:
Private Sub cboValdAnL_AfterUpdate()
Me.cboAffM.RowSource = "Select ... Where [LeaderID]=" & Me.cboLeader
Me.cboAffM.Requery
End Sub
The fieldname above...