Multiple Choice in a Form

Question

I was wondering how I could create a form that has a multiple choice question (check boxes). Based on what is selected, I want that to go into the table.

Eaxample;

Which state were you born?

 Florida

 California

 Texas

There would be check boxes, and based on the selection I want the answer to show up in the table.

Possible?

Thanks

Answer 1

3. What is your citizenship? Canadian Other (this one I'd need help for too as I have to have the end user use free format for "other" and need it to record the answer in the database in the backend)

The image below is of the model for my Questionnaire.accd demo, to which I gave you a link earlier.  As it stands the file allows for single or multiple choice answers to questions via combo boxes, but does not allow free text entry.  To add this would mean adding a text column to the Responses table.  In the fsubResponses subform  code in the Answer combo box's AfterUpdate event procedure could, if the answer is 'Other', pop up a little unbound dialogue form in which the free text value could be inserted.  On confirmation in the dialogue form the value would be assigned to the text column in the subform's current row, and the dialogue form closed.  The text would not show in the subform, but code in its BeforeUpdate event procedure could guarantee that the text column contains a value if 'other' has been answered.  It would be a simple task to show the text in the rptQuestionaires report, hiding the control if the answer is not 'other' by code in the details section's Format event procedure.

Answer 2

Yes this is possible. There are multi-value fields which many of us purists don't care for. Typically we would use a multi-select list box and use code to maintain a table like:

PersonID State

1 MN

2 FL

The state you are born probably isn't a good example since most of us are born in only one state. If this were states you have lived in, it would be better:

PersonID State

1 MN

1 WI

1 TX

2 FL

2 ID

3 OR

3 WA

Answer 3

Thanks for the reply. Would you know of any sites that go into detail about this?

I follow what you are saying, but need some clarity.

Answer 4

Yes this is possible. There are multi-value fields

Hmm.  Did DV123 mean "a field that stores multiple selections", or "a field that allows the user to select one choice from a several that are presented"?  I assumed the latter, but maybe I was wrong.

Answer 5

This is normally done with an option group, which is one of the standard control on the form design toolbar.  You can bind the option group to a field in the table that is your form's recordsource.  The value of the option group will always be a number, each number being associated by the design properties of the option group with one of the choices you set it up to offer.  So you will want to have a lookup table that can be used  queries to associate each specific numeric value with name of the state.