subreport in a field header

[Guest]

I'm driving myself mad...
What I'm trying to do is create a report with the following layout...


REPORT HEADER
lots of text explaining stuff (in labels)
___________________________________________________________________
"SECTION" HEADER
[Name of Section]
sub-report of section staff
___________________________________________________________________
"OFFICE DEPARTMENT" HEADER
[Name of Office Department]
___________________________________________________________________
DETAIL
[Position] [Name] [contact details] for each other staff member


It all works except for the sub-report in the "Section" field header. Every
time I add it, no matter what I set my child and master fields to it simply
doesn't appear and comes up with an error message "Enter parameter value -
Section"

Please help!!

 

[Guest]

Apparently either your main report or your subreport doesn't have the field
[Section] in their Record Source. Did you get the Link Master/Child using the
Wizard/builder or did you just type the values in?

 

[Guest]

Both the queries that the main report and subform are based on have the field
[Section] in them.

I try to link them by right clicking on the subform, going to Properties and
using the subreport field linker (where you select fields from the record
source). [Section] is there for both reports. I don't know what I'm doing
wrong!

Apparently either your main report or your subreport doesn't have the field
[Section] in their Record Source. Did you get the Link Master/Child using the
Wizard/builder or did you just type the values in?

--
Duane Hookom
Microsoft Access MVP

I'm driving myself mad...
What I'm trying to do is create a report with the following layout...


REPORT HEADER
lots of text explaining stuff (in labels)
___________________________________________________________________
"SECTION" HEADER
[Name of Section]
sub-report of section staff
___________________________________________________________________
"OFFICE DEPARTMENT" HEADER
[Name of Office Department]
___________________________________________________________________
DETAIL
[Position] [Name] [contact details] for each other staff member


It all works except for the sub-report in the "Section" field header. Every
time I add it, no matter what I set my child and master fields to it simply
doesn't appear and comes up with an error message "Enter parameter value -
Section"

Please help!!

 

[Guest]

I expect the issue is your choice of field names. I think Section is a
reserved word. I would create a new column/field in each record source like:

TheSection: [Section]

Then try to link on [TheSection]

--
Duane Hookom
Microsoft Access MVP

Both the queries that the main report and subform are based on have the field
[Section] in them.

I try to link them by right clicking on the subform, going to Properties and
using the subreport field linker (where you select fields from the record
source). [Section] is there for both reports. I don't know what I'm doing
wrong!

Apparently either your main report or your subreport doesn't have the field
[Section] in their Record Source. Did you get the Link Master/Child using the
Wizard/builder or did you just type the values in?

--
Duane Hookom
Microsoft Access MVP

I'm driving myself mad...
What I'm trying to do is create a report with the following layout...


REPORT HEADER
lots of text explaining stuff (in labels)
___________________________________________________________________
"SECTION" HEADER
[Name of Section]
sub-report of section staff
___________________________________________________________________
"OFFICE DEPARTMENT" HEADER
[Name of Office Department]
___________________________________________________________________
DETAIL
[Position] [Name] [contact details] for each other staff member


It all works except for the sub-report in the "Section" field header. Every
time I add it, no matter what I set my child and master fields to it simply
doesn't appear and comes up with an error message "Enter parameter value -
Section"

Please help!!

 

[Guest]

Thankyou!! That did the trick

I expect the issue is your choice of field names. I think Section is a
reserved word. I would create a new column/field in each record source like:

TheSection: [Section]

Then try to link on [TheSection]

--
Duane Hookom
Microsoft Access MVP

Both the queries that the main report and subform are based on have the field
[Section] in them.

I try to link them by right clicking on the subform, going to Properties and
using the subreport field linker (where you select fields from the record
source). [Section] is there for both reports. I don't know what I'm doing
wrong!

Apparently either your main report or your subreport doesn't have the field
[Section] in their Record Source. Did you get the Link Master/Child using the
Wizard/builder or did you just type the values in?

--
Duane Hookom
Microsoft Access MVP


:

I'm driving myself mad...
What I'm trying to do is create a report with the following layout...


REPORT HEADER
lots of text explaining stuff (in labels)
___________________________________________________________________
"SECTION" HEADER
[Name of Section]
sub-report of section staff
___________________________________________________________________
"OFFICE DEPARTMENT" HEADER
[Name of Office Department]
___________________________________________________________________
DETAIL
[Position] [Name] [contact details] for each other staff member


It all works except for the sub-report in the "Section" field header. Every
time I add it, no matter what I set my child and master fields to it simply
doesn't appear and comes up with an error message "Enter parameter value -
Section"

Please help!!