I have a combo box (cboNumber), when something is selected in the combo box I want to update the form accordingly.

cboNumber, txtName and txtCompany are all linked to adoData, therefore when something is selected in cboNumber I want txtName and txtCompany to be updated.

I have tried:

Private Sub cboNumber_Change()

adoData.Refresh

End Sub
but keep gettin a system error, which closes the application

I know it's a simple query, HELP.