Store Multiple Values from List Box

[Tezdread]

Hi all,

I was thinking/hoping of using a list box on my form to store multiple values, I haven't been able to find a way of storing any value so far so not sure how easy it will be?

How can this be achieved or is it just easier to use several check boxes (approx 8)

Thanks

 

[KenHigg]

Hum... I don't think a list box will provide you with the functionality you're looking for. I would say the check boxes or maybe a small subform...

(Just my 2cents )

 

[Tezdread]

cheers Ken, I wasn't sure so thought asking the question here would be the best thing...check boxes it is

 

[Mile-O]

I would suggest subform to be the appropriate method.

Using a series of checkboxes would imply that you have a repeating group in your table which violates database normalisation rules.