[RESOLVED] Set value of textbox from a combo box column

[carbo]

I am trying to set the value of a textbox named "Address" by referencing the value of column 1 of a combo box named "Location". The following code is not working for me. Please help

Private Sub Location_Change()
Address.Value = Location.Column(1)


End Sub

I have also tried the following code..

Private Sub Location_Change()
Address.Value = [Form]![Location].[Column](1)

End Sub

Resolution:
Private Sub Location_Change()
Address.Value = Location.Column(1, Location.ListIndex)
End Sub
Thank You "bushmobile"

carbo