Check Boxes

[HD20]

I have a subform with a drop down box containing about five items, however I have had a request to have check boxes for the items instead since one customer can have more than one of the items. Currently it is set up as a continuos form so they just keep selecting from the drop down box.

Is there a way to use multiple check boxes but have them feed into just one field (creating a new record as each one is checked)? Would it be better to create a separate field for each of the five items on the list and have the checkbox indicate yes/no as the item is selected?

Thanks in advance for your input.

 

[Sohaila Taravati]

You can have one checkbox but you can make a table for your items and that field can be a dropdown list. So, when each customer is chosen out of the dropdown list, the item can be chosen and then putting the checkmark. I hope that helps

 

[karmahum]

Hello.

You can accomplish easily, by placing a frame on your form. Make the frame bound to the field you are interested in populating...Then add 5 (or the number of lines from your current combo box) option buttons within the frame. You will then need to change the OPTION Value for the option buttons, i.e. 1 through 5.

When you select one of the option buttons, it will store that buttons Option Value in the underlying table. As a result, your table will no longer store the actual Text value, but rather a numeric value representing a text value (based on how you assigned the Options value...i.e. 1 = Sean, 2 = Mike, 3 = Lori, 4 = Eric, and last but certainly not least, 5 = John.

Enjoy!