 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Changing the source of a report
If I have generated a report with a given table or querry and I want to keep the format, but change the source (table or querry), how do I do that?  SignatureSee me for who I am and not who you want me to be,. That way no one gets disappointed! Assuming the form (or report) is open, you can use Forms![NameOfForm].RecordSource = "NewQueryName" or Reports![NameOfReport].RecordSource = "NewQueryName" SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > If I have generated a report with a given table or querry and I want to > keep > the format, but change the source (table or querry), how do I do that? >If I have generated a report with a given table or querry and I want to keep >the format, but change the source (table or querry), how do I do that? Open the report in design view. View its Properties; on the Data tab the first row is the Recordsource property. This will be either the name of your table or query, or a SQL string (a local query, basically). Replace it with your other query name. If you need to do this routinely, you should ask why you need different queries for (apparently) the same kind of data - might a single Parameter query letting you dynamically change the criteria for the query be an alternative? John W. Vinson [MVP] What if nothing shows up on the DATA tab? SignatureSee me for who I am and not who you want me to be,. That way no one gets disappointed! > >If I have generated a report with a given table or querry and I want to keep > >the format, but change the source (table or querry), how do I do that? [quoted text clipped - 13 lines] > > John W. Vinson [MVP] >What if nothing shows up on the DATA tab? Are you looking at the properties of the Report itself? Or the Detail or some other section? Be sure to get the right properties: right mouseclick the little square at the upper left intersection of the rulers in design view and select Properties. If you are, and there is a blank next to Recordsource, then your report is unbound and won't display any data (there's no data to display). You can set the property to the name of a query to display data from that query. John W. Vinson [MVP] Thanks. I'll check again. SignatureSee me for who I am and not who you want me to be,. That way no one gets disappointed! > >What if nothing shows up on the DATA tab? > [quoted text clipped - 8 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.