By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,199 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Using checkboxes to select rows in a form

P: n/a
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

May 16 '06 #1
Share this Question
Share on Google+
3 Replies

P: n/a
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.


May 16 '06 #2

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

May 16 '06 #3

P: n/a
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

May 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.