Combo box on subform in datasheet view

[Guest]

I need to be able to select several items, names, that would be listed in a
subform as a datasheet view tied to one record. I can't seem to get my combo
box and code working properly to add more than one name tied to one record
ID. Do I need to make a join table to hold the values?

How do I go about doing this?

 

[Michel Walsh]

Hi,


You either need a table and then a join, either a IN-list. To build the
IN-list, you can take your inspiration from
http://www.mvps.org/access/forms/frm0007.htm



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Thanks, I'll give it look-see and try to apply it and see if I can make it
work.