Unable To Update Text Box From Combo Box..

I'm trying to have the user select an item from a combo box which gets its values from a table with multiple columns. Once something is selected in the combo box the form will auto-update the adjacent text box to a value in the same row (different column). The combo box is called 'Media' and the text box is called 'Tape Cost'. When you select a type of tape in the combo box the adjacent text box should populate a value determined by the second column of the table. Instead I'm getting a message that the, "Method or data member is not found" and it highlights the red text below.


Here is the code I'm using:

Private Sub Media_AfterUpdate()
Me.Tape Cost = Media.Column(2)

End Sub


Not sure what I'm doing wrong here. Thanks!