wrong data appears in text box on report (1 Viewer)

[mghdb]

I have a field in a report that references a combo box. In the combo box there are two columns, the first column contains the full name of employees and the second column contains the employee initals. I'm using the employee initials as a criteria for the query in which the report is based on. For example, the employee would enter his/her initials and the report will display their particular information. The problem is that the field in which the employee name (full name) is supposed to appear in, the initials appear instead...please i need help. I thank you and appreciate any help regarding my dilemna.

 

[chrismcbride]

If you would like to refer ta combo box column value other than the one that is the Bound Column (ie the displayed column) then you can use the Combo Box's Column Property.
ie Forms!frmComboBoxName.Column(1)
Altenatively you could use a DLookup on the Report to find the initial from whatever Table they are stored in based on the Name value in the Combo Box.
Chris