Changing number value to text

[drblackard]

I am using a combo box to enter Employees names for training hours...I want to use a pivotchart but when i use the training hours table/form the pivotchart gives me the combo box numbers instead of the names. I know there is a formula or something I am suppose to use here or even a query but I don't have a clue as to how to do this....if someone would be so kind in directing me with instructions and help...thanks

 

[Dennisk]

The Combo box control has a column method, so as well as the column bound to the control you can refere to any column using the following notation

myComboBox.Column

where n is a number between 0 and the max number of columns -1.

However you should be linking the values from the combo box to the lookup table and returning the description in a query.