Current text in a Combo

[Mermogoat]

How can you get the current text of a Combo box? When I use the value property, it gets the value of the bound column, and when i try to use the text property, it gives me the error that the box must be currently selected. Is there another property or way I can get this? Thanks

 

[bjackson]

look at the rowsource query for the combo box
if the value you want is not the bound column then
you refer to the column that holds your value

eg =me![combobox].column(2) if column 2 holds your value

hope this helps

 

[boblarson]

And remember that the first column index number is 0.