开发者

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 mo开发者_如何学编程st of my function with macros and am intimidated by the code builder. Anyone willing to help a beginner?


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:

parameter as a drop down list

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

Below are the key components:

  1. Form's drop-down:

    parameter as a drop down list

  2. Macro setup:

    parameter as a drop down list

  3. Report. Please note the RecordSource is just Clients table (no WHERE clause etc.):

    parameter as a drop down list

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜