Reference a textbox column?

[Jeff Klein]

I have a combobox that shows the client first and last name.
The row source is

SELECT DISTINCTROW Employees.EmployeeID, [EmployeeFirstname] & " " &
[EmployeeLastName] AS EmployeeFullName
FROM Employees
ORDER BY [EmployeeFirstname] & " " & [EmployeeLastName];


I am trying to set a text boxes control source to [cbo_EmployeeName] but
all this is showing me is the EmployeeID number. Is there a way to
reference the column in the combobox?

 

[Guest]

Try...

Textbox.value = cbo_EmployeeName.column(1,cbo_EmployeeName.listindex)

 

[Jeff Klein]

Chris, Thanks for the reply...works great!