lookup and return value (1 Viewer)

rainbows

Registered User.
Local time
Today, 06:32
Joined
Apr 21, 2017
Messages
157
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

AWF VIP
Local time
Today, 05:32
Joined
Mar 9, 2014
Messages
3,731
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)
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:32
Joined
Feb 19, 2002
Messages
33,798
Or join to the company table if you need more than one other field to display. Then you can pick all the columns you want and bind them to the form.

WARNING though. If you do this, you MUST set the locked properties of all the lookup fields to Yes to prevent accidental updating. I also set the Tab Stop property to No so that the user just tabs over them when using the tab key AND, I frequently make them uenabled also which grays out the control.
 

Users who are viewing this thread

Top Bottom