CODEWITHSUNDEEP
ms-access
Marci
Marci

Reputation: 21

parameter as a drop down list

I am very new to access and would like to have users select report criteria from a drop down list of clients before running the report. The Client names can be lengthy, so asking users to type for parameters will not work. I have built most of my function with macros and am intimidated by the code builder. Anyone willing to help a beginner?

Upvotes: 2

Views: 7109

Answers (1)

Igor Turman
Igor Turman

Reputation: 2205

The task is:
You have some report that needs to display data filtered by user selected value(s) on the form
The screenshot below (MS Access 2007) shows the basic setup for this scenario:

enter image description here

Please not this simple solution does not require any VBA code.

Below are the key components:

  1. Form's drop-down: enter image description here
  2. Macro setup: enter image description here
  3. Report. Please note the RecordSource is just Clients table (no WHERE clause etc.): enter image description here

Upvotes: 2

Related Questions