Add query-buttons to a report

[sverre]

Hi

I have created a report with drag and drop of 20 queries.

If there is a need to see more details that should be possible for the user
by running other and more detailed queries than the ones used in my report.
Therefore I would like to add "buttons" to this report to make it possible
for the user
to run a more detailed query. Is that possible or should i use another
solution? As there are around 200 queries totally in my database I cannot
require the user to find the appropriate query to run. Easiast would be the
add the button beside the query result in the report or to add the detailed
query-buttons on page 2 of the report.


Many thanks in advance and I hope I have expressed myself clear!
Sverre

 

[Allen Browne]

You can add clickable command buttons to reports only in Access 2007, and
then only in Report View (i.e. they don't work in Print Preview.)

You are probably better of using a form.