Feel quite dim atm as i cant seem to figure this one out!
I have a list of teachers populations a comboBox with three columns, the first is their ID number (key column, hidden), the second is their name and the third is there department code (hidden).
The data i need is the department code, however .value gives me the key column value and .text gives me the Teachers name!
