How to display (unbounded) combo box information in a report?

[xinyin]

I have a form (name: fm1) containing a combo box (cx1). The combo box has 2 columns: the left column (bounded) is the employee ID (eID), the right column is the employee¡¦s names (ename). After the user has chosen an employee in the combo box, he can click a button in the form to open a report (rp1), rp1¡¦s source is the form fm1. In the report I want a text box (tx1) to display the chosen employee¡¦s NAME ¡V however since employee¡¦s names are not bounded to the combo box in fm1 (the employee ID does), so the report can show the employee ID only, but not the name related to the ID? Is there anyway to change the report around to fulfill this task without touching the bound structure /design of the combo box?

 

[pdldavis]

How about:

tx1 control souce =forms!form1.cx1.column(1)

 

[xinyin]

It works, thanks.