check box adding records to table

[andyw]

Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.

[Ed Robichaud]

In your table, have an field of Number-integer type. On your form, make an
option group bound to that field. Then with either check boxes or radio
buttons, the value of the choice will be stored to your table/field.
-Ed

"andyw" <an******@hotmail.com> wrote in message
news:10**********************@z14g2000cwz.googlegr oups.com...

Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.

[Pieter Linden]

"andyw" <an******@hotmail.com> wrote in message news:<10**********************@z14g2000cwz.googleg roups.com>...

Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.

Umm... what are you planning on doing with this kind of data? If you
store your data like this, working with it is going to be almost
impossible. For example, what if the user decides after clicking
option2 that he really does NOT want that value at all. how do you
get the data back out again? Parse it? (Happy coding!) How do you
summarize something like this? Parse, normalize, summarize? The point
I'm trying to make is this: think HARD about what you want to do with
the data *before* designing anything. Otherwise, if you do it wrong,
you're going have a lot of work to do over.