Adding subreports to main report from multilistbox Access vba

I am using Microsoft Access data base 2010 64bit I have a form "MainDatafrm with a Multiselect list box "ReportList" and a button "cmd1" I Have a main unbound report "Signedletter" I have 7 unbound reports Person1,Company1,Company2,Company3,Partner1,Partner2,Partner3 all the above 7 reports have labels that always have data in them and thats it (they are signed, Date, and depending on which report a label that says the reportName all of these are in the reportHeader section

I would like to pick which reports to add to my main report from my multiselect list box and not have the subreports keep repeating themselves. I can change the format of any of the reports

https://stackoverflow.com/questions/66620547/adding-subreports-to-main-report-from-multilistbox-access-vba March 14, 2021 at 10:30AM