I have a data entry form based on a Table with three fields. An autonumber field (primary key) a person-codenumber and a field which looks up its values from another Table.
On my form the last field is represented by a list box.
I want the multi select property set to simple or extended. When the user makes two or more selections is there a way that two new records are added to my Table?
For example If the user sets person-codenumber = 2223 and from the list box he selects both: "BlaBlaBla" and "Dddddddd", is it possible to have in my Table two new records? One having
(Autonumber)1 | 2223 | Blablabla |
and the second one:
(Autonumber)2 | 2223 | Dddddddd |
Thank you in advance
On my form the last field is represented by a list box.
I want the multi select property set to simple or extended. When the user makes two or more selections is there a way that two new records are added to my Table?
For example If the user sets person-codenumber = 2223 and from the list box he selects both: "BlaBlaBla" and "Dddddddd", is it possible to have in my Table two new records? One having
(Autonumber)1 | 2223 | Blablabla |
and the second one:
(Autonumber)2 | 2223 | Dddddddd |
Thank you in advance