User is asked to save report when closing

[Doggie97]

I've created a query based on variables entered on a form and I'm setting the reports recordsource to this query....so the recordsource is changing every time the report opens. I'm guessing this is why the user is asked to save the report every time they go to close it. Is there anyway to stop that from happening? I don't want the user to have deal with this as it causes confusion.

Thanks!

 

[dhookom]

Have you considered setting the Record Source to a saved query and then simply changing the SQL of the saved query prior to opening the report? This might result in no design changes in the report after opening.

Duane
Hook'D on Access
MS Access MVP