Access Link TextBox to ComboBox

Hi

I have a combobox with the following datasource. I have a text box that I want to be automatically populated with the item in the second column of what is selected in the ComboBox. I am using =[cboManuf].[column](2) in the control source of the text box but nothing is showing when I select an item in the ComboBox

SELECT t_Manufacturer.Manufacturer, t_Manufacturer.Country
FROM t_Manufacturer
ORDER BY t_Manufacturer.[Manufacturer];