Hi
I have looked through past posts but can't quite match what I am looking for.
I have a set of existing reports (4 in total) that asks for the same criteria (a specific date) in each report. Currently I have a form with one button per report.
Is it possible to have one button that will run all 4 reports? I have tried to incorproate it all into one button in VBA but it requests the date 4 times for each individual report of the 4.
Can you have it ask for the date once and apply it to all 4 reports?
I can't (as in not allowed to) change the existing reports from the existing 1 button per report form so possibly need to do all the code in the new one click button.
Any suggestions?
I have looked through past posts but can't quite match what I am looking for.
I have a set of existing reports (4 in total) that asks for the same criteria (a specific date) in each report. Currently I have a form with one button per report.
Is it possible to have one button that will run all 4 reports? I have tried to incorproate it all into one button in VBA but it requests the date 4 times for each individual report of the 4.
Can you have it ask for the date once and apply it to all 4 reports?
I can't (as in not allowed to) change the existing reports from the existing 1 button per report form so possibly need to do all the code in the new one click button.
Any suggestions?
Last edited: