Select All in Combo Box List

[kdub]

I apologize if this is easy to figure out. But, in Access 2010 I have a multivalue combo box list in a form that I would like to have users be able to Select All without having to click each individual check box. Similarly, I would like the option of deselecting them all, but this is not as important.

I do ask that someone could walk me through this step by step if they could. I greatly appreciate all the help. Also, please let me know if you need more specific details.

[burrina]

Your post is confusing to me. By select All, what do you mean? You would refer to the Column(0) for multiple results. What does the check boxes have to do with this? Are they suspposed to be checked using the value from the combo box? Very confusing???

[kdub]

I apologize for the ambiguity. Like many check box lists in other environments, I would like an option to click or check something that will check every box in the list. There are around 30 items in my list, and I just want users to be able to check every box with one click.

[burrina]

Your saying Combo Box, are you really talking about a List Box?

[kdub]

I believe it is a multivalue combo box. I am attaching a picture to show it if I am incorrect with my terminology.

[burrina]

Looks like a ListBox to me but can't tell with the Picture. If you created it you should know for sure.

[kdub]

I created this field initially in my table as a lookup from another table listing these nubmers. I set the lookup to allow for multiple values to be selected. In the field properties on the lookup tab in design view, I selected combo box as the display control.

From this table I created a form by clicking on the form button on the create tab. This is why I think it is a combo box.

[burrina]

Please review this site suggestion : http://access.mvps.org/access/lookupfields.htm

[kdub]

So, the impression I am getting is that I should never be using lookup fields for my tables. My next question is what I should be doing instead of using the lookup field. The lookup is simply gathering these particular ID's for use as stated previously.

I still do not know what to do regarding my initial question. I am looking for a way to check all those boxes with a single click. It seems I am going to need some step by step help regarding all of this. All of this help is greatly appreciated.

[burrina]

Here is the code to check all check boxes.

Dim ctl As Control 'Select All CheckBoxes.
For Each ctl In Me.Controls
If ctl.ControlType = acCheckBox Then ctl.Value = True
Next ctl