Using Checkbox as Multi-Selection in Form Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003 (Access 2000 file format).
I have a main form for searching a subform (eventually will be two
subforms). The subform is based on a multi-table query.

What I would like to be able to accomplish - add a checkbox to the
query/subform to allow selecting multiple records. The selected records will
then be output to a report using a button on the main form.

After searching on the net, I still haven't been able to find a solution to
this problem. Any ideas of how this can be accomplished? By the way, I
would like to do this without adding a checkbox field to the main tables, as
this will be used only for selecting records.

Any and all help would be appreciated.

-Fizzlesquirt
 
Thanks for the reply Duane.

Unfortunately, the multi-Select listbox won't work due to the way you have
to use CTRL-click to select multiple records. It isn't user friendly enough
for this application. Plus if you accidentally forget to hold the CRTL while
selecting and wipe out everything that's already selected.

I was hoping to use an expression in the query or something to accomplish
this... Is this even possible?

-Fizzlesquirt
 
I would like to build an airplane so I can go flying, but I don't really want
to have to put wings on it. They are bulky and don't fit in the driveway
very well.
 
Either train your users to use the "Extended" multi-select or just switch to
the "Simple" multi-select so users don't have to use their control key.

Allen Browne has some great code at http://www.allenbrowne.com/func-12.html
which allows you as the developer to add a button to clear or select all
items in the list box.
 
Back
Top