View Full Version : Bound Check Boxes


Airica
04-16-2001, 12:40 PM
Hello all. I could really use some help with bound check boxes. I am creating a form that is linked to a table containing over a hundred records. These records are the responses I received from a survey written in HTML, which included check boxes. An example of a field in the table that answers a check box question looks like this
apples, oranges, grapes, plums
Is it possible to create check boxes in a form that will be linked to that field and will autmoatically check the box next to apple, the box next to oranges, and so on?
Can anyone help??? Thank you so much.

Jack Cowley
04-16-2001, 02:18 PM
Are the terms "apples, oranges, grapes, plums" all in one field or is 'apple' in a field by itself, 'orange' in a field by itself, etc.? If they are in separate fields then you can use code something like this to check the boxes...

If Me![ATextBox] = "apple" then
Me![ACheckBox] = -1
End if

If the 'fruit' is all in one field then you will need code to extract the individual items and then go from there.

llkhoutx
04-17-2001, 12:07 PM
Create an OptionGroup with checkboxes for each type of data; they are mutually exclusive and are generally numbered sequentially, 1,2,3, . . . n.

You bound data merely indicates which, i.e., 1,2,3 . . . or n.