I have a report containing 'Actions' linked via an 'ActionID' field to a subreport containing 'Progress'. By default, the subreport repProgress lists all the Progress records for each Action.
However, on a form, I want to give users the option to see the same report, but with the latest Progress only. I have two queries, qryProgress and qryProgessLast (field names are identical). I'm trying to change the recordsource of repProgress to qryProgressLast when applicable.
I'm making a nice collection of error messages, but not a great deal of headway! I've tried putting code in the OnOpen event of the main report and the subreport, but no joy. I may be barking up the wrong tree altogether..
However, on a form, I want to give users the option to see the same report, but with the latest Progress only. I have two queries, qryProgress and qryProgessLast (field names are identical). I'm trying to change the recordsource of repProgress to qryProgressLast when applicable.
I'm making a nice collection of error messages, but not a great deal of headway! I've tried putting code in the OnOpen event of the main report and the subreport, but no joy. I may be barking up the wrong tree altogether..
