I have a list box in a form and it should show DeptName, I have RowSoure for this listbox is Select DeptNo, DeptName, DeptDescription from Dept.
The data are here
1 CS Computer Science
2 HR Human Resource
I want the list box text show DeptName and value use DeptNo, How I can do it?
Thanks in Advance.