Display Lookup in a Text Box instead of Combo Box 1

[dmuroff]

Hello,

I have a Combo Box which is a lookup field with 2 columns. 1 column is bound (ID) and the other is not (description).

The ID is of no use to the users and since the form should be uneditable I would like to display solely the description in a text box.

I have tried to create a text box and take the value of the combo box but it can only display the ID.

Is there any way of doing this?

Thanks!

 

[PHV]

Either set the ColumnWidths to "0;" (this will hide the ID column) or, if you insist on the textbox, use Me![Combo name].Column(1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dmuroff]

The only reason why I don't like using a combo box is because it has the dropdown which will allow users to see the other records.

That is why I asked about a text box so it would eliminate that dropdown.

Do i put Me![CboCompanyID].Column(1) in the control source of the text box?
I tried this and I got #name?.

 

[dmuroff]

Can I get rid of the selector on the combo box?

 

[dmuroff]

Solved!

Put txtcompanyid=Me![CboCompanyID].Column(1) in the form load procedure.

 

[almoes]

HI dmuroff,

I am trying something similar, to which property of the text box do you write 'txtcompanyid'? thanxs!

cheers,
alej

 

[dmuroff]

almoes...
txtcompanyid is the name (name property) of the text field.