Returning the text or name for the field and not the bound ID numb

[CJ]

This is what the control source for the control reads:
=[cboEmpNumber].[column](5)
The value for column 5 should be the company name and not the company ID#...
but when I view the form, only the company ID# show up in the text boxes,
and not the company name. When I run the query in cboEmpNumber, it is
correctly showing the company name in the query....
what am I doing wrong in the above formula....?

 

[Albert D. Kallal]

This is what the control source for the control reads:
=[cboEmpNumber].[column](5)

The above would return row 6....the column() function is zero based.....

try;;

=[cboEmpNumber].[column](4)