Combobox need value of column 1 in table en value of column 2 in report

[pot2000]

I have a form with a combobox and need de value of the first column in my table this is not a problem but when I use a query to select data and want the value of the second column in a report I get the value of the first column in the report is there a way around this???

Greetings Raymond

 

[MarkK]

Check out the "Column" property of the ComboBox object.

 

[pot2000]

What should I check out. If I change the bound column I get the text in the table.

 

[boblarson]

Okay, we'll spell it out for you

Me.YourComboBoxNameHere.Column(1)

will give you the SECOND column ( Column(0) would give you the first).

And what lagbolt was trying to say was try looking in the help file (trying to get you to think a bit because it is explicity laid out in the help file).

 

[pot2000]

Thanks that helps a lot. I don't know why I din't look in the help file before I posted the question here.