Resolved Displaying a name instead of a number

[subraven]

I am building an application that shows (for one thing) what employee is assigned to what client.
I am using - ahem - UNBOUND controls throughout.
What I need to know is how can I get my client form to show
the employee name instead of the employee number
I'm using an Access database.

Thank you VB Gurus!!!

[James Stanich]

Select EMPLOYEE From Table Where CLIENT = ' & VARIABLEHOLDINGCLIENTNAME HERE & "'"

[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.

[Beacon]

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?

[James Stanich]

Select lastname, Firstname From Table Where reportsto = ' & EmployeeNoVariabletoPass & "'"