Help with report parameter please

[mitchem1]

I need to run a report by employee. I have created a form that contains an unbound combo box (cboSelectEmployee) that lists all employees from the employee table. In the report query, I have entered [Forms]![frmSelectEmployee]![cboSelectEmployee] in the criteria field of Employee ID. The report works and returns all data as it should. However, on the report itself, I want to display the Employee's name. I have created a text box with source [Forms]![frmSelectEmployee]![cboSelectEmployee].[Column](1). However, I get the #Name? error in this field. Thanks in advance for any help.

 

[David R]

In your query, try including the table that contains both EmployeeID and EmployeeName. Then draw the name field down into your query, instead of the ID field. The ID field should still link your tables so you don't get screwy results.

HTH,
David R