Combo box on report question.

[illy2k]

I have a report which gets crtiteria from a form. The form sends the driver # the person picks to the reportand it is filtered by driver. This driver number is sent to a combo box and in turn the combo box shows the correct driver name. I hide the bound column so that only the driver name shows and not the number. The only problem I have is that even though I have the query governing the combo box has both driver last and first name, the combo box only prints the last name. Does anyone know how to force the combo box to print both last and first name.

This code for some reason only prints Driver Last:

SELECT [Employee/Drivers].EmployeeID, [Employee/Drivers].Last, [Employee/Drivers].First FROM [Employee/Drivers];

And I checked the column widths, they are 0";1";1" and still only driver last name prints. Any ideas?

 

[Rich]

Combo boxes serve no useful purpose on a report in this case, change them to text boxes,add the Employee Drivers table to the report's underlying query, the fields will then be available for your report