Dynamically assign recordsource in Report

[rational]

I have a series of reports that open on a Splash screen. After they are opened I wish to change each of their recordsource properties via code to a parameter query which asks for 2 dates.When I check the design mode of the reports they still have the same recordsource. Is it due to this database is in Access 95. I am sure you can access this property but why isn't it changing?? TIA

 

[rbowes]

I believe that you will have to change the recordsources of the reports before they are formatted or on the OnOpen event.&nbsp;&nbsp;There is no requery method for reports so that kind of ties your hands.&nbsp;&nbsp;Do you have to open them up on the splash screen first?<br><br>Let me know.<br><br>Bob B.