Solved

Access - remove focus off of option box

Posted on 2007-11-14
1
1,045 Views
Last Modified: 2008-02-01
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'"
0
Comment
Question by:SharonInGeorgia
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 20281832
Me.grpRegion.Value = NULL
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question