Create Records Based Upon Selected Values in ListBox

[matomo]

Hi all,

Can some one please help me with this little problem. I am developing a database for Task Management which will have Project Staff selected from a ListBox which will populate the the Project Staff field which is a list box on the Project Form.

What I want to do now is to have Project Form create a new record for each selected Project Staffs in the Project Table when the form is closed or saved (i.e. if two Project Staffs are selected two records are created in the Project Table).

Is it possible to accomplish this using a ListBox? I have attacheda copy of the database that I am working on. It is in Access97.

Thanks

matomo

 

[llkhoutx]

Use temporary tables for both list boxes, when selecting a record from one, add it to the other and then delete it from the first. Have a record in bo5th lists will cause problems for your users. I guarantee that they'll select the same one multiple times unless you code around it.

 

[matomo]

Thanks Pat,

Your Example was very useful.

matomo