lookup and return value

[rainbows]

Hi

I have been trying without any luck to get the company name to automatically go to the field "company" using the information in the field "assigned to"

i have a form called "home " of which 2 of the fields are called " company" and "assigned to" . this information comes from drop down boxes from my query called "contacts extended " when I select the person I assign the work to in the from "home" can it look at the name and put the company in for me

thank you

 

[June7]

Why do you need to save the company name? If you save the person ID and you have a table that shows which company this person is associated with, the company can always be retrieved in query linking tables.

Include the company as a column in the combobox RowSource. Expression in textbox can pull company by referencing the combobox column by its index. Index begins with 0 so if company is in third column, its index is 2.

=comboboxname.Column(2)