A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sub Report changes Name of Group Header



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2005, 07:38 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Sub Report changes Name of Group Header

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant get my report to fit on one page rmoritzky Setting Up & Running Reports 16 February 10th, 2009 01:35 PM
how to set up group header as column header in a report? lizzie Setting Up & Running Reports 1 September 14th, 2005 01:03 PM
REPORT GROUP HEADER TEXT BASED ON GROUP FIELD VALUE RICH C Setting Up & Running Reports 1 May 17th, 2005 06:25 PM
Report group header ordering ... Jamie Risk General Discussion 3 February 23rd, 2005 12:16 AM
Still Hoping for help with a Query problem Don Sealer Using Forms 15 November 13th, 2004 06:24 AM


All times are GMT +1. The time now is 03:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.