Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Report Control Source (Acc97)

    Thanks for everyone' s help on an earlier issue. Now another beginner question:

    I have created a report that prints all of the records in a table, and messed around with the formatting in design view until it is how I want it. I'd like to copy this formatting of the fields and labels to use for other reports that are based on queries. I have created a duplicate report, but I haven't been able to change the fields correctly yet.

    0. Is there a way to create a new report based on the formatting of an existing report, but using different data?

    1. Assuming you copy an existing report, is there a way to change the source of data universally for a report? (I.e. change the source of all data from Table Blah to Query BlahBlah) I was not able to immediately see a way.

    2. If it needs to be done for each field separately - If I go into the Text Box popup for a field, in the Data field I assume I want to change the Control Source. But when I change the Control Source from
    Subject
    to
    =[Query1]![Subject]
    which is the syntax pasted in by the Expression Builder, when I try to view the report preview, it pops up a parameter box (when Query 1 doesn't have one) and then returns #Error in the Subject field.

    Any thoughts? I'm assuming something in the syntax of the Control Source is incorrect, but I don't know what it is.

    Thanks a bunch.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Report Control Source (Acc97)

    While in report design place your cursor in the box at the junction of the two margins in the upper left. This is the place to select the report. Right click, properties, record source. Then use the down arrow to select your new query. I usually create a new query for each report. That should get you started.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Changing Report Control Source (Acc97)

    If you have a base report that can use a number of different record sources then all you would have to do is to just change the record source (assuming all your fields are the same name). You can change the record source in the OnOpen event of the report.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Location
    California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Report Control Source (Acc97)

    Tom and Pat - thanks a bunch! That was exactly what I was looking for and more than I had hoped for. Much appreciated. <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •