Command buttons on reports?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

Is it possible to create a report that lists records and have a command
button on the report that opens a selected record?
I've done this with forms but not reports
TIA
Tony Williams
 
Tony:

Reports are graphic images, they do not support active controls like command
buttons. However, it wouldn't be too hard to add such a button to your
report's toolbar (assuming a custom toolbar). Stop by our web and look in
the free files area for a download called "Other Reports" the demo db it
contains shows how to create a button on a toolbar that will print just the
current page of the report, you could easily modify the way that button
works to rather than printing, pull the primary key of the page displayed
and launch a record.

Keep in mind however that if the user modifies the selected record while the
report is opened, changes will not be reflected in the report until it is
re-run.
 
Thanks Steve I'll have a look at that
Tony
SA said:
Tony:

Reports are graphic images, they do not support active controls like command
buttons. However, it wouldn't be too hard to add such a button to your
report's toolbar (assuming a custom toolbar). Stop by our web and look in
the free files area for a download called "Other Reports" the demo db it
contains shows how to create a button on a toolbar that will print just the
current page of the report, you could easily modify the way that button
works to rather than printing, pull the primary key of the page displayed
and launch a record.

Keep in mind however that if the user modifies the selected record while the
report is opened, changes will not be reflected in the report until it is
re-run.
 
Back
Top