Combo Boxes

Hi,

Can anyone tell me how I can get the value of a third column in a combo box to print in a text field? I'm using Access. I have a combo box that contains 3 columns. The combo box is bound to column one. I have two text fields. When the combo box is updated I have first text field = to the combo box value which is column 1. How do I get second text field = to the third column of the same combo box?

Appreciate any help. Thank you.

If you're using access, then you should be able to use index notation like this:

combobox(1).value or combobox.value(1), etc

You havent mentioned if your using ASP, VB, etc... If the above technique doesn't work can you please provide us with more information of your setup.

I am using an Access form with VBA behind the form. When I try combobox(3).value or combobox.value(3) I get an error "Procedure let not defined". I don't know what other step needs to be done. Thank you.