Can I create a hyperlink in a report that when clicked will replace the same value as what I click into my query criteria.
For example…
I may get the following results in a report
Change this filter
Investigate root cause of this failure
Purchase this item
etc
I want each result to be a hyperlink that on click, it transfers the same ie. “Change this filter” to the criteria box in a query.
In turn this query will open a form that I can edit more information about the item.
Thanks in advance,
John
