A multi select form using unbound check boxes

[CJ_London]

Thought I would put this up since it is a fairly common topic and I have put it up elsewhere - selecting records from a list for onward processing without the need for a table based tickbox. Similar in concept to the conditional formatting version I provided here

multi select form

Responding to a thread where I suggest using a multiselect listbox, I thought it would be useful to upload this simple example where you can turn a form into a multi select form. It only does a 'simple' version but with more work could probably also be extended to mimic the extended form. The...

www.access-programmers.co.uk

This example enables a user to tick a checkbox against each record they want to process. There are options to select all and deselect all and to view just those records selected or not selected. And then a button to (in this case) print labels.

 

[Pat Hartman]

@CJ_London I like the concept. Have you thought about updating it to clear the checkmarks or to toggle them? If you accidentally check a box, there is no way to uncheck it.

Was there a reason you used the gotFocus event rather than the Click event?

 

[June7]

Brilliant and simple.
I can uncheck selected after filter but have to toggle between Not Selected and Selected to refresh list.

 

[CJ_London]

@Pat Hartman - it only occurs on the first one selected. For my own apps, I had already corrected it. If you select all then deselect the ones you don't want it works OK. Selecting all then deselecting all it also works. - edit: as noted by June

I've attached a corrected version

 

[Pat Hartman]

Thanks Chris. Could you please update the download sample on AWF?

 

[CJ_London]

Can you not see v2 in post #4? Or do you mean something else?

 

[Pat Hartman]

Sorry, I thought we were talking in a different thread because that's where I got the link to come here. Thanks again for the update. I'll just go away for now before I say anything more stupid.

 

[isladogs]

I've only just noticed this thread.
Although apparently not widely known about, you can also create multiselect filters in continuous forms without the need for unbound checkboxes or similar methods. For example:

For details on how this is done using the UI or code, see

Multiselect Filter in a Continuous Form

Unlike datasheet forms, continuous forms do not have a multiselect filter option. This article shows how the feature can easily be added, either from the user interface or using VBA code.

www.isladogs.co.uk

I've also created a YouTube video demonstrating this approach

 

[Gasman]

@Pat Hartman - it only occurs on the first one selected. For my own apps, I had already corrected it. If you select all then deselect the ones you don't want it works OK. Selecting all then deselecting all it also works. - edit: as noted by June

I've attached a corrected version

@CJ_London

Just come to this from a link in another forum.

Where are all the normal events associated with a button. I understand this is a toggle button, but that still has a click event etc?

ToggleButton.Click event (Access)

Office VBA reference topic

learn.microsoft.com

ToggleButton object (Access)

Office VBA reference topic

learn.microsoft.com

Trying to fathom out how it works.

TIA

 

[CJ_London]

the toggles are associated with an option group (optView), so no code required on the toggles - it's in the option group after update event

 

[Gasman]

the toggles are associated with an option group (optView), so no code required on the toggles - it's in the option group after update event

Ah, Thank you.