Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamically assign recordsource in Report

Status
Not open for further replies.

rational

Programmer
Apr 12, 2000
3
CA
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
 
You might find more help posting to the Access forum, I've never used version 95. But here's a sugestion: rather than change the recordsouce property to a parameter query, why not make your splashscreen into an input form and collect the input there? That way you can build comboboxes for your users to select appropriate values from.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top