Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Using option control to open report

Posted on 2014-02-05
2
Medium Priority
?
294 Views
Last Modified: 2014-02-05
On a form I have an option group.  There are three choices the user can select from.  When the user clicks the first radio button I want a report to open that show only records where "Closed" in the underlying query is true.

Here is what I have but it doesn't work:

DoCmd.OpenReport "rptOpenReturns", acViewPreview, , "Closed" = True, acWindowNormal

--Steve
0
Comment
Question by:SteveL13
[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
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 39837218
Try this:

DoCmd.OpenReport "rptOpenReturns", acViewPreview, , "Closed = True", acWindowNormal

Note that I moved the end quote in the WHERE argument. Access expects to find a valid WHERE clause statement there (without the word "WHERE", of course).
0
 

Author Comment

by:SteveL13
ID: 39837256
Perfect!!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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 …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

598 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