get listbox values from combobox multiples selection

[ryprobg]

in this db a want to get the emails in listbox from selectin combobox multiple choises.
how can i get it into table (t_dci) automatiquely thank you for help me.
db in the attachements below
login : admin
passe :1234

 

[theDBguy]

Hi. The simple answer is you don't. If the email info is already stored in a table, then you don't need to store it again in another table. Since you are already storing the ID for those email data, then all you need to do is use a query to join the two together when you need to use the email data.

 

[ryprobg]

Hi. The simple answer is you don't. If the email info is already stored in a table, then you don't need to store it again in another table. Since you are already storing the ID for those email data, then all you need to do is use a query to join the two together when you need to use the email data.

can you expalin in the db and post it to test

 

[theDBguy]

can you expalin in the db and post it to test

Open "Query1."

 

[mike60smart]

Hi

You are using MVF's in your table's which are not recommended.

Each of the fields in your MVF should be records in a related Table

 

[ryprobg]

Open "Query1."

result:
choose one value in MVF (respavCBO) query1 give the related email
but if you choose two valus in MVF (respavCBO) query1 give just one email and not two

 

[ryprobg]

Hi

You are using MVF's in your table's which are not recommended.

Each of the fields in your MVF should be records in a related Table

how that in this case : look at db in the attachement

 

[mike60smart]

When you create a record in t_dci
Will you only want to record 1 instance of Quoi ?
Will you want to record more than 1 Concerne?

 

[ryprobg]

When you create a record in t_dci
Will you only want to record 1 instance of Quoi ?
Will you want to record more than 1 Concerne?

yes i change combobox qoui and concerne to simple one value to record one value. but in resposable avisé i want MVF then i want to record multiple values in one time the target is to get the related emails stored in resp_acc table

 

[mike60smart]

If you need to record multiple Emails related to the 1 DCI then you need a table to record them and NOT an MVF

 

[ryprobg]

If you need to record multiple Emails related to the 1 DCI then you need a table to record them and NOT an MVF

can you show me how please?

 

[theDBguy]

result:
choose one value in MVF (respavCBO) query1 give the related email
but if you choose two valus in MVF (respavCBO) query1 give just one email and not two

In that case, I still wouldn't store it. Open "Query1" again.

 

[mike60smart]

can you show me how please?

See the attached

 

[ryprobg]

See the attached

is this true what ever number of respav for example > 2 ???

 

[ryprobg]

See the attached

what a geniuos

 

[ryprobg]

this concept don't help me to get email values when i select names from combobox.
the concept i want is to load emails when i select names

 

[mike60smart]

Can you explain what it is that you need and how the example does not fit your requirements?

 

[arnelgp]

your email_resp field in table t_dci is a Short Text, therefore in your form i
made it also as Textbox (not listbox).

try changing "Résponsables avisés" in the form and see Email changes
with your selection.

 

[theDBguy]

Just FYI to others who may follow this, this discussion has been continuing on in two other threads.

related combo_box to get emails and send it with outlook

hello programmers i have a mini form used to send emails to two person ( nom_hc) listed in (resp_acc) with emails ( email_hc) in the form the user should select in cbo1 person1 and in the cbo2 person 2 and he will get emails in two listboxes below and record it in t_dci table source of the form...

www.access-programmers.co.uk

and

how to email with vba from a form using cbo and list box selection

hello programmers i have a mini form used to send emails to two person ( nom_hc) listed in (resp_acc) with emails ( email_hc) in the form the user should select in cbo1 person1 and in the cbo2 person 2 and he will get emails in two listboxes below and record it in t_dci table source of the form...

www.access-programmers.co.uk

 

[Pat Hartman]

@theDBguy Thanks for linking to the other threads.
@ryprobg Welcome to the forum but in the future, please don't start multiple threads on the same question. It wastes our time and confuses you.