Solved

MS ACCESS - Trouble with Report - SubReport in section footer

Posted on 2014-09-04
3
316 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
3 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
Comment Utility
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 34

Expert Comment

by:PatHartman
Comment Utility
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
Comment Utility
That's it!! Forgot about that!
Thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now