Option buttons

[dcashwell3]

I'm new to Access, obviously, and I'm building a DB for our PTA. I'm trying
to check all volunteer oppourtunities that a member is interested in for each
record. It needs to be able to facilitate multiple choices in the form, seen
at a glance on the form, and be flexible enough to change daily if
neccessary. I've gotten everythig else to work but this.

 

[Allen Browne]

Do not try to do this with lots of options in one table.

Instead, you need a relational structure that needs at least 3 tables:
- Volunteer (one record for each person);
- Interest (one record for each type of interest);
- VolunteerInterest (one record for each interest of each volunteer.)

More details:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html