Multiplevalue in a Listbox

[Gachettes]

Hi everyone,



In advance thanks for your help.

I have a "Contact Details" Form that allows to modify the fields for clients detail in a table "Contacts".

In this form, I have a combobox to choose the Company in which the contact works "CompanyCombo" that is linked to a second table "SociétéT"

In this "SociétéT" table, I have a field called "Relation" which is a multiplevalue field that allows to select the different employees in relationship with each company

I'm trying to automatically see the different employees associated to each client (ie. the entire multiplevalue field string):
1- when the form is opened
2- when the "CompanyCombo" value is changed to a new Company name

I tried Dlookup, but that brings only one value... and I don't know how to solve this.

Any help would be more than welcome

regards

[June7]

Multi-value field does not save a 'string'. Sounds like you need a better understanding of what a multi-value field is https://support.office.com/en-us/art...C-6DE9BEBBEC31
http://www.kallal.ca/Articles/fog0000000006.html

I NEVER use multi-value field.

[orange]

Gachettes,

How about showing readers your tables; and describing the "business" in plain English?