[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Access - remove focus off of option box

Posted on 2007-11-14
1
Medium Priority
?
1,054 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 66

Accepted Solution

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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 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