Display (concatenate) multiple columns from same combo box???

[sprtrmp]

I have a form that has a combo box with multiple columns. column 0 (hidden = employee number, column 1 = last name, column 2 = first name). on the form, this combo is used to select which employee's record is being displayed.

From this form, I can open a report that simply shows/prints an employee's record. from what I can tell, I have the form filtered correctly to where it opens the report to the correct employee, and I have a text box that I need to show the employee's "Lastname, firstname".



What I cannot seem to figure out is how to concatenate the 2 columns from the combo box on the form into one textbox on the report. I have tried using a few variations of the following as the control source for the textbox on the report:

=[Forms]![frmAssigned].[cmbCrewID].[column](1) & ", " & [column](2)

Does anyone have any ideas?

THANKS!!!

[CJ_London]

have you tried

=[Forms]![frmAssigned].[cmbCrewID].[column](1) & ", " & [Forms]![frmAssigned].[cmbCrewID]. [column](2)

[sprtrmp]

I just did, and it worked.

I didn't think i would have had to direct it all the way to the Forms... column(2) location for the second time, i would have thought (incorrectly, obviously) that getting it to the control the first time would have done the trick.

Ah well, thanks for the quick response.