I have a form where they choose options for a report and which report type they want to open. If one of the options is not chosen I do not need to run a certain subreport and its underlying query. I could, as I have it set to do now, let it always run but just set the visible property to false when the option is not checked. But that would take load time and, with large amounts of data, could slow it down.
So, I need to set the subpreports record source to "" so that it will not run the query when not needed.