I originally had 4 departments each with it's own Database. Some of the data tables were duplicated between the different databases. I've recently designed a new database that combines the 4 databases into a single database. Each of the 4 had various reports but again there was some similarities for example each had a Birthday List and Mailing label Reports. The new design has a demographic table so the customer is only listed once and there are 4 tables for the data unique to each of the original databases. Is it possible to set the Record Source for the Report in the Load Event of the Report? That way I can use a case statement that grabs the department from a combo box on the report page and get the right data without having to design the same report 4 times for each department.
If not the load event of the report is there another Report event that I should use?