Solved

MS ACCESS - Trouble with Report - SubReport in section footer

Posted on 2014-09-04
3
336 Views
Last Modified: 2014-09-04
I am creating a telephone directory.
This report is primarily sorted by OfficeID (1,2,3) We have three offices.
The report works fine from TelephoneDirectoryQ
I want to show the support extensions from another query in a subform in the footer of the OfficeID section.
I need this subreport to filter only the items that match the section OfficeID.
If I just insert SubformSUPPORT into the footer, it shows all office support extensions for every OfficeID fotter, not just the ones from the sorted OfficeID section.
When I link any Master Fields / Sub Fields and then run the report, I get a box asking for a value.
help?
 subform.jpg
0
Comment
Question by:gpchicago08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 40304722
Try putting a hidden control in the group footer section that contains your Office ID. Verify that the value of this OfficeID control is set correctly prior to setting the visible property to No. Then set that as your Link Master Field for the subreport.
0
 
LVL 37

Expert Comment

by:PatHartman
ID: 40304750
The reason you need to add the hidden control is because Access rewrites the RecordSource for reports (it does not do this for forms) and it isn't smart enough to check code or apparently the master/child links.  Access removes ALL columns that are not specifically bound to a control on the report so if you need something in code or elsewhere, you MUST bind it to a control.  As pdebaets said, it doesn't have to be visible.
0
 

Author Closing Comment

by:gpchicago08
ID: 40304865
That's it!! Forgot about that!
Thanks!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can not open the Access Help ? 3 38
Database (Access Table) Security Access 8 57
Cant delete records in query 8 48
Combo box with two columns question 7 38
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question