textbox follow up

[Paul]

Can anyone tell me if there is a way to take a textbox
that is getting data from a table and in a form can I
have it display the data name instead of the value?
What i mean is i have a field with this
Expr1: [CompanyName] & " " & [ContactFirstName] & " " &
[ContactLastName]
as the row source and if it is a drop down list or combo
box it shows the info i am looking for but i do not want
to change it so i would rather have it as a text box, but
when i do it only shows the ID number ie.. i want it to
say "ABC company John Smith" but it will show customer id
" 1 " if it is a text box ONLY

thank you

 

[John Vinson]

Can anyone tell me if there is a way to take a textbox
that is getting data from a table and in a form can I
have it display the data name instead of the value?
What i mean is i have a field with this
Expr1: [CompanyName] & " " & [ContactFirstName] & " " &
[ContactLastName]
as the row source and if it is a drop down list or combo
box it shows the info i am looking for but i do not want
to change it

Simply set the Locked property of the combo box to True; or, you could
just have a calculated field in your form's Recordsource query with
the above expression.