Checkbox help

[NateHaze]

Hello,


I'm trying to create a form that's kind of like a survey. A simple example:

Name:
Age:

Colors you like:
(Checkboxes for blue, green, red, yellow)

Numbers you like:
(Checkboxes for 1, 2, 3, 4)


Let's say Bob is 9 and likes green and yellow and numbers 1 and 4.The report should print out:

Hello, Bob!

You are 9 years old.

You like the following colors:
green
yellow

You like the following numbers:
1
4

I'm not sure how to get the checkboxes to pass the values to a table when checked. Any ideas?

[khalid]

Okay!

The easy way is to achieve this is creating a new text field for each check box and store the check box's data to the appropriate field.
For example: color checkbox, blue, green and red, yellow... you can save the caption of the checkbox to those fields when clicked.

private sub checkboxgreen_click()
FieldColorGreen.Value=checboxGreen.caption
end sub

This an aircode, but hope will give some idea.

[NateHaze]

Thanks for the quick response. I am able to pass the values now! However, I don't know how to format the report so that it only prints the relevant data. One part of my example was:
You like the following colors:
green
yellow

How do I display only green and yellow without a bunch of space where the blue and red fields would be if they were selected as well? It's like I need to create a dynamic query that only grabs columns that aren't null...

[khalid]

Yeah, and one approach is to create a Sub Report on the main report where the data will come from your subTable, (you would have definitely created the main table and sub-table with foreign key and primary key relationship)

Hope this help.