Multiple Actions On_Click won't work

[PinkLady50]

I have a form with two sections. The top of the form uses a combobox to get the Contract Number. I have an On_Click that I am using to display the Contractor and Name of MATO (Contract Name) but it will only pick up one field.

SELECT tblContractLevelMATO.[Contract Number], tblContractLevelMATO.[Name of MATO], tblContractLevelMATO.Contractor FROM tblContractLevelMATO ORDER BY tblContractLevelMATO.[Contract Number] DESC;

Private Sub Contract_Number_Click()
Me.MATO_Name = Me.Contract_Number.Column(2)
Me.Contractor = Me.Contract_Number.Column(3)
End Sub

Is there a better way to get corresponding data into these text boxes besides using an On_click procedure?

I have another part of the form where I will be using this logic as well. Once I select a Task Order I need to display 9 fields from the table that match that Task Order Number in various textboxes on the form.

[pbaldy]

I'd use the after update event. The column property is 0 based, so you'd want 1 and 2, not 2 and 3.