Creating checkboxes for a form based on a query

[dabbler]

Hi there,

I'm having trouble with a query/form that requires checkboxes. The form is based on a query. The query returns around a hundred rows currently, of which the data is a list of contacts.

Functionality
-------------
What I want is the ability to check each of the rows that I wish to assign to a "report queue", which will be stored in another table. Likewise, rather than just having a checkbox for each row I would like to have a "select all" and "clear all" options at the top of the form in order to blanket select/deselect all the checkboxes for each row.

I've been scouring the forums and reading books on this but I can't find the solution.

Any ideas?

 

[dcx693]

Which part is confusing you? The checking and unchecking of all the boxes at once?

How are the checkbox results being saved? If you've got it setup where you have a reportID, userID and a checkbox, then you can use an update query where you set the checkboxes to True (or false) for a particular report.

 

[dabbler]

Thanks for the response. Okay, my query in the continuous form is

select A, B, C, D from table1 (A=unique key)

The form is a continuous form. The checkbox values are not to be stored in the database, but I
want them available next to each row, initially as unchecked.

The process I need is:

1. Query results return (for example)
=====================================

A B C D
1 Todd Analyst California
2 John Manager Texas

2. Select the person you wish to add to the queue
=================================================
In this example we will want to check Todd.


3. The value 1 (value of column A) need to be added to a table called "Queues" (ready for printing at a later date).
The "Queues" table will have columns called "colQID" (unique key) and colA (FK to Table 1, col A).
I should also have the option to "select all" or "deselect all" here.

4. I will then have a form that will manage the different queues and on a click of a cmd button it will print a report
for each and every row in the "queues" table.


NOTE: This is why I don't wish to store the checkboxes in the "table1" table. It wouldn't make any sense. I am fine with
everything after step 3. It's just these checkboxes and the select/deselect I am struggling with.