Pulling data from combo box

[Jwnagz94]

Hello. Im using access 2010

so ive set an an access database and I have a single combo box. I want the other field on my form to reflect the data based on the combo box. I have the combo box row source coming from the data base. When pulling data, =[Combo0].[Column](1), works. However when i try to pull column 2 with =[Combo0].[Column](2) no data is retrieved.

Thank you for your help in advance.

 

[alansidman]

Look at this link. I think that this is what you will need.

Autofill