Manipulating Command box in a access report in detail section

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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jack" wrote in message
...
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.

Thanks for your suggestions, Allen. I appreciate it.

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jack" wrote in message
...
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.