Save data by checkbox

[Wombat]

Reference thread https://www.accessforums.net/showthr...-on-two-tables

If you want to save the checked selections for each person, need a another table - a junction table - because the relationship is many-to-many. Then use form/subform arrangement. Main form bound to People, subform bound to junction table (PeopleClothes). The Clothes table would be RowSource for a combobox in the subform. Each record in the subform would be an item of clothing selected from combobox.

This might help with an issue that I'm working on except there's a twist:

Instead of a checkbox for which type of clothes they're wearing, if I pull up a man's record, I would like a form that lists "Pants" "hat" and "Shirt" and I could have a textbox where i could describe Each.

Women's records have "Skirt", "Blouse", "Sunglasses" and "shoes" (4 items as opposed to 3 for men).

I'm picturing a continuous form filtered by menswear or women's (depending on the person I pull up) but I can't figure out how to get it to save the record of my descriptions.

Any ideas?

[June7]

This is what bound comboboxes are best suited for. Otherwise, will need code to save the selected item.

[Wombat]

This is what bound comboboxes are best suited for. Otherwise, will need code to save the selected item.

So if I want to use a textbox, I need code to save it? I guess that wouldn't be too hard, I just didn't even think of it.