Filter Parameter for Access Services Form

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
ShadowITAsked:
Who is Participating?
 
macarrillo1Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.