I have a form (mfrm) which has text fields that are used as criteria for a query (mqry). There is a subform (a report actually) called mrpt which has a recordsource of mqry. The sql for mqry is updated when a button is clicked, but i can't find the right syntax to get the subreport to refresh in mfrm.

Thanks in Advance.