Is there anyway possible to set the record source property of a
sub-report programatically for each record of the parent report?

Due to what seems to be a bug in Access, a Left Join query I have is
not working properly and the only way I can seem to get around this
process would be to change the record source property of the sub-report
for each record in the parent report. Any help would be GREATLY
appreciated.

Thanks!