Hello All,
Thank you for all of your ideas. Unfortunately, I still can't figure this out. I am going to attempt to upload the database (front and back ends).
I have a report called rptContractsByDateFinalized. The source is qryContractsByDateFinalized. Originally, the user wanted to use a beginning date and ending date as criteria for the column DateFinalized. I used this for criteria in the query: Between [Enter beginning Date Finalized] And [Enter ending Date Finalized]. Then the user decided he wanted all records 5 years or older than a specified date. So I switched the criteria to this: <=DateAdd("m",-60,[Enter Date]). When I run the query, works like a charm. When I run the report, it prompts for Enter Date as it should. However, it then prompts for Enter beginning Date Finalized and Enterending Date Finalized which are no longer a part of the query. The V - Total Deep Search is finding references in the report but I sure can't figure it out. Sorry for the long description and thanks for any advice.