Change combo box to textbox

[bid19123]

I have a form with a subform on it. The main form part has data in combo boxes. I dont want the values in the main part to be editable. I can lock the combo boxes but the fact that they are a combo box looks strange if they cant be edited. When I change from combo to form the data on the form changes from a text value to a record ID number. How do I change the combo boxes to text boxes without altering the returned data?



Thanks

Alan

[ranman256]

combo boxes can hold many values (columns) and it usu hides the key.
text boxs hold 1 value and it MUST be the key.

so choose:
combo box to see text (yet store the key)
or make many text boxes , a visible one to show the text, and invisible to hold the key.

me, i keep combos.

[bid19123]

Thanks for that,

Its not a major problem I just think that on a form where you do not want people to change the data then a simple textbox looks better than a combo.

[Minty]

If you don't need to edit the values then simply add the combo lookup table to your forms records source, link it to the stored id field and bring the text in from the lookup table.