List box property set to simple or extended

ion97

Registered User.
Local time
Today, 23:38
Joined
Feb 28, 2001
Messages
27
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
 
Yes, add the two selected Names to the table using DAO code.
 

Users who are viewing this thread

Back
Top Bottom