Hi there: I saw a great response to what I need, but the code doesn't work for me.
I am building an Access 2003 Form that has multiple List Boxes, each having up to (10) items and the List Box is set to allow multiple choices. I need the users to be able to select multiple items from each List Box AND fill in other fields, lastly saving the record to a single table.
Example:
List Box (Conditions 1) (has 5 choices of which up to all 5 can be selected)
Same with List Box (Conditions 2, 3, & 4).
Then the user needs to fill in a number of other fields and then use the command button to "Save Record".
All the Fill-In fields are separate fields in the "Save To Record" Table BUT the List Boxes each have (1) field that needs to store all choices from each List Box. Example List Box Conditions 1 should store as Broken, Cracked, Scratched. etc....
Can you help me figure this out?
Thanks, Nikki