Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to create a form whereby I can add multiple values to a table. I want to select the values using a list of check boxes, but there are a lot of values- is there anyway to automatically generate check boxes based on all the possible values in a column? I see how it is possible to create a multi-value from a checkboxlist, but this is not what I want.

The column is 'Skills', and examples of values I want to add- several per individual- would be things like 'sewing', 'carpentry', 'arts and crafts' etc.

New skills will be added in the future, so i want the list on the forms to update to include the new skill with a new textbox. To me it sounds like it should be an easy enough thing, but there is no option I can see for it.

share|improve this question

A subform which contains a checkbox and a txtbox for 'skills' would solve the problem. This would mean that you can have one or more skills listed, with a checkbox next to each of them.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .