Originally posted by subraven
I guess I did not express myself clearly.

See code below:
With rsEmployee
lblLastName.Caption = ![lastname]
lblFirstName.Caption = ![firstname]
lblAddress.Caption = ![address]
lblCity.Caption = ![city]
lblState.Caption = ![region]
lblZip.Caption = ![postalcode]
lblPhone.Caption = ![homephone]
lblExt.Caption = ![Extension]
lblTitle.Caption = ![Title]
lblReports.Caption = ![reportsto]
lblHireDate.Caption = ![Hiredate]
lblRate.Caption = ![billablehours]
End With

The field
lblreports.caption = ![reportsto]
is showing the employee number instead of the employee name.
In the Access database - the employee is assigned by their number.

What I need is the code to display the First and Last names instead of their employee number.

Thanks again.
This reportsto field is apart of a relationship with another table yes?
Or you used the lookup wizard yes?