James has attended:
Access Intermediate course
Access Advanced course
Using Macro to change Record Source in Reports
This is a simple document / template retrieval system.
I have one report in one style which, when generated offers hyperlinks to the required document or template.
It can run many alternative queries (I'm interested in 123 permutaions)
I have a grid of command buttons on a single control panel.
Each button represents one query and the associated report.
How, with one click of the button, do I get the query to select the correct parameters, return the data for and become the link in the record source of the report that I want to view?
The idea is one click to see what is available, and one click to access the resource.
The simpler to understand the better please. I'm brand new at this.
RE: Using Macro to change Record Source in Reports
Hi James
Thanks for your post. We may well be able to find a solution but we will need to see your files to investigate further.
As this falls outside the scope of this forum what we would ask is for you to email your files to us we can then let you know if a solution can be found, trainer development time required and any related costs.
Please drop me an email if you are interested in looking at this further.
Kind regards
Jacob
