<div>
move them outside of the option group. &nbsp;By definition, an OG can only have one valid value.
</div>


<div>
You need to change the &quot;look&quot; of the control also. &nbsp;Option groups, which are usually rendered as radio buttons are intended to make you think of a radio. &nbsp;When you push one button, you get that station. &nbsp;It doesn't make sense to be able to press multiple buttons at once. &nbsp;If you want to go with multiple selections, you need multiple controls. &nbsp;In this case, I would use checkboxes because people understand that checkboxes stand alone and so in a properly designed form/document multiple checkboxes may be checked at the same time.<br />
<br />
Alternatively, you could use a multi-select list box. &nbsp;I would recommend the listbox if you forsee the choices being expanded. &nbsp;Using individual checkboxes would require changes to the form and query if you wanted to add/change the options. &nbsp;However, with a listbox, you can simply add a new choice to the RowSource table and no programming is required. &nbsp;The downside is that they are a little harder to set up initially since you would need a code loop that goes through the listbox collection and assembles an In() clause with all the selected values. &nbsp;They you would build the SQL to include this In() clause. &nbsp;Remember, that due to the way querydefs work, you can't simply use the In() clause as an argument since changing the In() clause would be considered a physical change to the queyr and so would require the query to be re &quot;compiled&quot;. &nbsp;So, to use the In() clause, you need to build the SQL on the fly. &nbsp;You can then save it as a querydef or pass it into a form or report and the form/report can take the SQL String and save it to its RecordSource in the Load event.
</div>


<div>
So I cut and past the buttons outside the group. Delete the group. The .values go away. <br />
So I need to check if the button is clicked (True) and set a named value now for the vba instead or 1 2 or 3 &nbsp;(data value) ?
</div>


<div>
you have to iterate to all controls to check ifor the value of the toggle button that is outside of an Option Group<br />
<br />
dim ctl as control<br />
for each ctl in me.controls<br />
&nbsp; &nbsp; &nbsp;if ctl.controltype=actogglebu<wbr />tton then<br />
&nbsp; &nbsp; &nbsp; &nbsp; if ctl.value=-1 then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msgbox ctl.name, ctl.value<br />
&nbsp; &nbsp; &nbsp; &nbsp; end if<br />
&nbsp; &nbsp;end if<br />
<br />
next
</div>


<div>
You are going from an option group (concept 1) to individual checkboxes (concept 2) &nbsp;--- start from scratch. &nbsp;Everything is changing and it will be easier. &nbsp;Cut and paste isn't going to save you any work. &nbsp;Checkboxes are true/false rather than a numeric value so you don't need checkbox 1 to return a 1 and checkbox 2 to return a 2, etc. &nbsp;Now that you have three controls rather than one, your code will refer to each control separately. &nbsp;<br />

<pre><code class="code-1 nolinks" id="code-20-41375370-1"><span>If Me.chkbox1 = True Then</span>
<span>    'do something</span>
<span>End If</span>
<span>If Me.chkbox2 = True Then</span>
<span>    ' do something</span>
<span>End If</span>
<span>If Me.chkbox3 = True Then</span>
<span>    'do something</span>
<span>End If</span>
</code></pre>
Or in a query<br />
Select ... From ... Where somefield = Forms!yourform!chkbox1 OR somefield2 = Forms!yourform!chkbox2 or somefield3 = Forms!yourform!chkbox3;<br />
If the data is bound, you also need to add additional columns to your table in which it would be saved.
</div>


<div>
@Pat<br />
I do need to return the 1,2 and 3. These coincided with DocumentType values on my table. I understand I will need to recode. <br />
@Rey<br />
I will try this option. This allows me to keep the toggles which the users like and are used to and allow me to set my values or even booleans and send as parameters to my queries.<br />
<br />
-Thanks all
</div>


<div>
Select ... From ... Where <br />
(somefield = 1 AND Forms!yourform!chkbox1 = True) <br />
OR (somefield = 2 AND Forms!yourform!chkbox2 = True)<br />
OR &nbsp;(somefield = 3 AND Forms!yourform!chkbox3 = True);<br />
<br />
If you use Toggle buttons Then<br />
Select ... From ... Where <br />
(somefield = &nbsp;Forms!yourform!Toggle1) <br />
OR (somefield = &nbsp;Forms!yourform!Toggle2)<br />
OR &nbsp;(somefield = &nbsp;Forms!yourform!Toggle);<br />
<br />
I do not recommend using radio buttons when multiple selections are allowed even if that was how the options were previously presented. &nbsp;In the previous presentation, the options were mutually exclusive which is implied by the radio button. &nbsp;Checkboxes &nbsp;imply multiple selections. &nbsp;Toggle buttons are ambiguous so a user might try to press more than one, but he might not. &nbsp;There is a great deal of written material on user interface creation and expectations.
</div>


<div>
This was the easiest one to implement per company standards and user specs.<br />
Thanks Rey
</div>


<div>
<div class="content wysiwyg-content">
I have 3 Toggle Buttons in an option group. I.E. only one button is enable and the .Value is used in a query. <br />
Now the use wants to be able to pick 1, 2 or all 3 buttons and do the query selections off of the .Value each button has. <br />
I can do the query. <br />
What is the best way to allow multiple toggle buttons to be picked?<br />
<br />
-Thanks
</div>
</div>


I have 3 Toggle Buttons in an option group. I.E. only one button is enable and the .Value is used in a query. 
Now the use wants to be able to pick 1, 2 or all 3 buttons and do the query selections off of the .Value each button has. 
I can do the query. 
What is the best way to allow multiple toggle buttons to be picked?

-Thanks

Toggle Buttions multiple selections

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.