An Easy Question (hopefully!)

[dbrooks]

I'm referencing a value in a combo box on an open form for a text box in my report. Instead of getting the value I get the location on the list. For instance My combo box could have red, green, and blue. If I highlight Blue and run my report (I have a text box that says [Forms]![MyFormName]![cbobox]) my report says 3, instead of blue. Could someone tell me how to get that value instead of the location. Thanks -db

 

[Rich]

You have to reference the column number add
.Column(1)to the end of your control source change the number to the column that contains the colour.Remember column numbers start from 0.
HTH

 

[dbrooks]

I might be missing something, but I won't know what the column number is since, depending on what color they choose it will change from 0 to 1 to 2. Thanks for the quick response.

 

[dbrooks]

I figured it out, sorry I didn't give you enough information. What the problem was is that it wasn't bound to the correct column, it was bound to the index, instead of the name. (I have a table for each of the combo boxes I've created, and that table has an index, and a name). Thanks for all your help I really really appreciate it. Thanks -