I have done this before in various ways, the most successful were.
1. Depending on user selection, I created a temp table with all the details and linked the Report to the temp table.
2. Depending on the user selection, I actually deleted the query the report was based on and rename the required query as the source for the report.
Query1 by name
Query2 by job
Query3 by area
Copy Query2 to QueryX
Re: selecting report from two different recordsource
Originally posted by skodidhi
Can a single report is selected from two different Record Sources?If yes, how can we achieve this.
Thanks in advance
You can use a SELECT statement depending on what the user has chosen
Select Case userSelection