Thanks John, Can you provide a little help on the code? My query name will be: qry_WOsummaryByDate_EnteredBy
Thanks :) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, January 23, 2006 2:46 PM To: [email protected] Subject: RE: [ms_access] Changing a reports record source Mike- You can change the RecordSource property in the Open event of the report. Perhaps set a public variable with the SQL or name of the query you want to use and have the code in the Open event pick it up from that. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 23, 2006 12:35 PM To: [email protected] Subject: [ms_access] Changing a reports record source Hi All, I have a basic report template that I want to use. How can I modify each version of the report to use a different record source (query)? I don't want to have to recreate the same report 10 times. Thanks :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
