Solved

Access - remove focus off of option box

Posted on 2007-11-14
1
1,044 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now