?
Solved

Filter Parameter for Access Services Form

Posted on 2012-03-27
1
Medium Priority
?
473 Views
Last Modified: 2012-04-13
Hello Experts,

I am trying to replicate a ParameterizedReportProject form found within the Sample Templates Project Web Database.  Specifically I am trying to add a drop-down filter parameter for a "Location" field within my ProductivityLocation report.

I am not having any luck and am receive several errors related to incorrect path BrowseTo.

If you could provide some assistance I would appreciate it.

Thank you
Global-Productivity-Web-Database.zip
0
Comment
Question by:ShadowIT
[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 9

Accepted Solution

by:
macarrillo1 earned 2000 total points
ID: 37807987
Create a lookup query for Location. As:

Query Name: LU_Location
Table: Productivity
Fields: ID, Location
You may want to change your query to only have the location field and do a group by on the location. Depends how you are using the location.

In your Parameterized Report Location change it to layout view.
In the properties of the dropdown field change the Row Source
to make use of the Lookup query (LU_Location).
Change your view to Form view and test your dropdown field.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Introduction to Processes
Suggested Courses

764 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