Using checkboxes to select rows in a form

Hi there.

I'm not well-versed in MS Access, but I've been reading the
documentation to no avail to find a way to solve what seems to me a
rather simple issue.

I have a query containing two columns, taken from different tables.
These are displayed in a continuous form; what I want to do is add a
checkbox for each row, so that users can select any number of these for
a process to loop through. Thing is, using an unbound control is
useless, as Access views it as a single instance, not one per row; and
adding a row to the source table is out of the question, as this is
strictly temporary data that should not be stored. I'm at a loss at how
to do it, and would very much appreciate any hints.

Best, Karim

re: Using checkboxes to select rows in a form

In reality, you have stated what you need to do.

In order to add a checkbox to each row you have to add a checkbox to
each row.

One way

1) create a local table that contains ALL of the fields that are shown
from your query AND a check box.

2) Create a query that will delete all records from that table

3) change the current query form a select query to a append query

4) Change the form/subform that currently uses that query to now use
the table or a query on that table.

5) use that table with the check/checked boxes as the source for
whatever processes you were going to do.

6) Where/whatever button you were using to come to the form now,
instead have it perform execute the query form step 2 and step 3.

The table is a temporary table addressable by that particular user and
will essentially disappear the next time you enter the form.

Ron

re: Using checkboxes to select rows in a form

Here is another person asking a similar question and the two answers he
came up with....

http://groups.google.com/group/micro...9fc43f03b1dacb

re: Using checkboxes to select rows in a form

Thanks. I was handling it more or less this way, but I felt it was
somewhat of a kludge, and I thought I might be missing something
obvious. Thanks for your help. Karim