Several approaches you could take:
- use a combo box with those choices
- use a multi select listbox and drop the select all and clear selection controls
- use listboxA to move selections to listboxB and use B choices
I'd go with option 2, especially since Select All doesn't allow you to pick only 2 in a combo box. It's not clear to me what part of this you want assistance with - form design, methodology or sql building.
Last edited by Micron; 10-28-2022 at 11:33 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.