Originally Posted by
jzwp11
What you want to do can be done with VBA code. What I normally do is to have a form where the user enters the parameters and then the code behind a button on the form executes the code to open the report based on those parameters entered or not.
I assume that the recordsources for the 2 reports are queries that differ only in the WHERE clause. Can you post the SQL text of those two queries? Can you also provide more detail on the fields that are tied to the parameters (datatype etc.)?