Multiple checkboxes in a form to build a string

[adamrj]

I'd be very grateful for some help with an access form I'm working on. I don't have a lot of programming experience so please bear with me.

From a dropdown field in the form it's currently possible to choose a geographical region for which to generate a report. The data populating this dropdown is pulled in from a Value List as follows:
" ";"*";1;2;3;4;5;6;7;8;9;10;11;12;13;EU;WD

I now need the ability to choose various different regions simultaneously which is not possible with the current method. I've looked into a nested continuous form and a multi-select combo box or list box, but none of these are as user friendly as my preferred method.

What I would like is 15 checkboxes plus a 16th to select/unselect all. When any of these checkboxes is checked, I need to create something like a dynamic value string or temporary table to hold the list of chosen regions until the generate button is clicked at which point the data is used to generate the report and cleared. I also need a piece of code to check/uncheck all the boxes.

I would be extremely grateful if someone could point me in the right direction.

 

[Frothingslosh]

For starters, if I didn't just use a list (which really is probably your best approach), then I would instead use one combo box, with an associated button that adds the selected value to a list control so that the user can see all of the selected values easily. Then have an 'execute' button that pulls the values from the list and generates your report.

You really want to avoid something like 15 checkboxes, simply because if you ever add or remove options, you would need to go into the form and adjust both the form and any queries involved. My approach would handle changes like that without having to modify anything.

 

[spikepl]

As Frothingslosh said.

 

[adamrj]

Many thanks for your responses, this looks like a good way of doing it.