I can't seem to find the answer to my question anywhere. Here it is: What is the best way to capture Checkbox information from a form and write it to to a database? In my situation, Users have to be able to select their preferences as they fill out a client profile. I have set up 2 tables, Users and Preferences in an Access DB. The Users table will capture username, name, address, etc. while the Preferences table has preferenceID, username and preferences as the fields. Users can select as many as 15 preferences so I figured it would be better to use 2 tables. I can't figure out how to capture the Checkbox info and write to the Preferences table. Should I even have these 2 tables? Please help!