If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SubReport changes Group Header in 2000
Thanks for taking the time to read my question.
I have a report with 2 fields in it. They sit in the Header of the field MORD (a number). I used Sorting and Grouping to make the header. I n the detail I want to put the subreport which is linked to the main report by linking MORD to OrderNumber (which is in the sub report). When I add the sub report and either let Access define my link, or define my own link, then try to preview the report, it asks me for OrderNumber in a dialog box. There is no reason for this. If I don't have the sub report in the report, it doesn't ask me. If I open the subreport on it's own, I don't get this prompt either. Then I noticed that the header name of my group on MORD is now OrderNumber. Access changes it. I don't know why. So the prompt is a result of Access not being able to find the field "OrderNumber" in the main report, which it shouldn't be able to, as it is not there. Why is Access2000 doing this? Is my procedure in adding the subreport wrong? I'm using the SubReport/SubForm button in the ToolBox to add the subreport. Thanks again for taking the time to read this long post. Brad |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Hiding page header when group header visible | Sam D | Setting Up & Running Reports | 1 | August 12th, 2005 01:27 AM |
Tough group header problem :( | Rocket Frog | Setting Up & Running Reports | 3 | March 17th, 2005 06:46 PM |
Requery Subreport For Each Group | Melissa | New Users | 0 | September 30th, 2004 07:26 AM |
Group in subreport | Sunny | Setting Up & Running Reports | 3 | May 26th, 2004 01:52 PM |