Multiple selections from a sub-form

[chris6976]

Hi Folks

I have a Job creation form with a workforce sub-form. I want the possibility of selecting more than one employee from the workforce and displaying them all in rows.

Is this possible only in Datasheet view or am I attempting the unattemptable?

I have another sub-form for suppliers where I have got three combos to select a maximum of three suppliers and have set the display so it appears correctly.
But this wont work for an ever-increasing number of suppliers.


Any help would be gratefully received ...!

 

[PHV]

And what about a MultiSelect ListBox ?
You may then play with the ItemsSelected collection.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[chris6976]

It did indeed!!

Many Thanks