Manipulating Command box in a access report in detail section

[Guest]

Hi,
I have a report where it accesses a query that shows category and the total
category sales. There are eight records in this query. Normally, the category
and the total category sales, if put in the detail section of a report would
produce this report. However, the way the report needs to be done is that a
command button would replace the category. Now when viewed, the command
buttons would show corresponding category names. I need to know how does one
code in such a situation where the command button caption captures the
corresponding category name when the report displays. Any help/suggestion is
highly appreciated. Thanks in advance.

 

[Allen Browne]

You cannot place a working command button on a report.

Reports are desinged as printouts, and clicking a command button on a piece
of paper does not work very well. That means you will need to find another
approach.

If you are comfortable with VBA code, you could create a custom toolbar for
the report, with buttons on the toolbar that set the report's Filter
property (remembering to set FilterOn as well.)

Alternatively, you could use a popup form that floats over the report to
provide those buttons to filter the report.

 

[Guest]

Thanks for your suggestions, Allen. I appreciate it.