Check boxes

[Rob001]

i have made a form with several check boxes. I want the results of the clicked boxes (more than one can be selected) to be found from a select query.

The thing is, i have also used an option group, and i can relate the value of each option to those i have stored in a table - i know how to do that and it works. But using seperate check boxes doesnt seem to have anything to do with values and so i'm stumped.

 

[jon98548]

If I understand what you have, you need a checkbox field in your table for each checkbox on your form. Connect each checkbox on the form to the corresponding field in the table. Like I say, I think I understand what you are trying to do. Hope this helps.

 

[Rob001]

that is the sort of thing i want to do but how do i do it? How do i connect the check boxes and the fields in the tables?

 

[Mile-O]

Find the form's RecordSource property and set this to the appropriate query or table.

Then you can set the ControlSource of the checkboxes to the relevant fields in your table or uery.

 

[Rob001]

Right, i think i have done what youve insturcted:

The checkboxes were called check132, check134, check 136 and check138. I have created a table with those 4 field names. I have set the record source of the form to that table. For each check box i have set the control source to the field with the same name in the table.

OK. So thats what i have done. Is this what you meant for me to do?

If it is, the thing i stated i wanted in the first place was for a query to collect data on which boxes were selected on the form. From what i said i did above can you tell me how to create the query?

 

[jon98548]

Query that table with criteria of 'true' in the checkbox fields.

 

[Rob001]

Ive finally managed to solve the problem - thanks for all your help and pointing me in the right direction.

In the end i worked out that in Access everything that is true is given a value of -1, and everything false is given a value of 0. I used these values in the tables and queried the fields on the form to those in the table.

Access becomes a lot easier in places when you know that true = -1 and false = 0. Is this common knowledge amongst you Access Pro's?