Text box to show a value

[Guest]

i would like to add a text box in my form that shows the company name when i
write the company_id in a field. ie: company_id 001 the text box automaticlly
shows Microsoft. All the requierd data are in (Company) table.

 

[Duane Hookom]

Is the company table in your query?

 

[Guest]

It might be in a query or a table that linked to the form

 

[Guest]

you got what i mean ?? i have a form which used to enter data to a table.
This table is only has the copmpany_id field which is linked to another table
contains the company_id ,and the company name. The user will be asked to
enter the company_id in the form ,and i would like to add a text box to make
him shore that this company_id belongs to the right company by display the
company name in it. The text box will read the company_id which has been
entered by the user ,and Retrieve the company name from the other table. got
it ??

 

[Duane Hookom]

Use a combo box to enter the ID or name. If you display and select the ID as
the bound/first column, you can display the other column from the combo box
with a control source like:
=cboCompanyID.Column(1)