<div>
<div class="content wysiwyg-content">
My option group has four values. &nbsp;Value 2 opens a report. &nbsp;Upon closing the report, the user returns to the option group where value 2 is still selected. &nbsp;Using VBA, Is there a way to deselect value 2 so that the user can look at the report again without having to select another option button?<br />
<br />
&nbsp; &nbsp; If grpRegion.Value = 1 Then<br />
&nbsp; &nbsp; DoCmd.OpenForm &quot;frmForecastREGION&quot;, acNormal, &quot;qryForecast&quot;, &quot;Region = 'ECE'&quot;<br />
<br />
&nbsp; &nbsp; ElseIf grpRegion.Value = 2 Then<br />
&nbsp; &nbsp; DoCmd.OpenReport &quot;rptMoMgtLv5ALL&quot;, acViewPreview, &quot;5-2MGTLv5ALL&quot;, &quot;Region = 'ECE'&quot;<br />

</div>
</div>


My option group has four values.  Value 2 opens a report.  Upon closing the report, the user returns to the option group where value 2 is still selected.  Using VBA, Is there a way to deselect value 2 so that the user can look at the report again without having to select another option button?

    If grpRegion.Value = 1 Then
    DoCmd.OpenForm "frmForecastREGION", acNormal, "qryForecast", "Region = 'ECE'"

    ElseIf grpRegion.Value = 2 Then
    DoCmd.OpenReport "rptMoMgtLv5ALL", acViewPreview, "5-2MGTLv5ALL", "Region = 'ECE'"


Access - remove focus off of option box

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.