Related fields to Maximum Grand Total

I am creating a subreport where I need some information on the last record created. I am using the Maximum Grand total function to get the most recent Recnum at the bottom. How do I get another field from that record ID in the report footer with the Recnum?