Not sure that fits the bill. As I interpret, belarin wants to open the name report from the category report and filter it to the name contained in one of the many records of the category report. Where criteria is needed for this of course, but it's not enough IMHO. The question is probably about how to decipher which record and which field in order to accomplish that, rather than the prompt currently used.
belarin, the behaviour you describe is often done by double clicking on a report row and using the value of one (or more) of the fields as criteria for some action to be taken. That is because the record in the report can accept the double click action and the row clicked on can be known. If you place a single button in a report header or footer, once it takes the focus, there is no current record so how do you specify which record is desired, let alone which fields? AFAIK, the only way you can do this is to put the button in the detail section so that it is a control on the record, like the other ones. It will appear on each record, but can be used to distinguish between one record and another this way.
Last edited by Micron; 05-28-2017 at 07:11 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.