Run-time error '438'

[rdhall75]

I'm pretty new at access and am having trouble getting my text box to auto populate based on the selection of a combo box. The combo box selections are populated from a separate table with the locations being in column 1. Column 2 of the table contains the regions that coincide with the locations in column 1. I'm trying to get my text box to populate with the region that coincides with the location that's selected in the combo box. Currently I'm using the following string however, every time I select a location I get a Run-time error '438'.

Private Sub ComboOrigLoc_Change()
Me.txtRegion = Me.ComboOrigLoc.Column(2)
End Sub

Does anyone have a suggestion on how to fix this or a better way to populate the test box

[jonh]

Column index is zero based.

[rdhall75]

What do I need to do to fix it?

[jonh]

Try changing the 2 to a 1.