Select records from query using added checkbox

[greeknl via AccessMonster.com]

Hallo,

I have a subform in which I show records resulting from a query displaying
certain data from two tables. I would like to add a checkbox to every entry
of this query, so the user can select the query-records he wants to use to
perform additional tasks with.

E.g. Say the query collects data on persons and their jobs based on certain
criteria. The user must be able to (de-) select the persons he would like to
leave out of a report that will be made once the user has decided on the
persons.

Also I would like to have all the checkboxes initially checked, so the user
only has to deselect some or none.

Is this possible without any changes to the original tables?

Thank you

 

[Douglas J. Steele]

No, you need to put a boolean field in your table.

Note that if you're in a multi-user environment, you'll have problems with
this approach, since everyone will be updating the same table with their
choices.

If the list of possible choices isn't too long, you might consider using a
multi-select List Box instead.

 

[greeknl via AccessMonster.com]

Ok if it cannot be done otherwise this is what I will do.

Thank you very much for your fast reply