Solved

MS ACCESS - Trouble with Report - SubReport in section footer

Posted on 2014-09-04
3
330 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
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 36

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

820 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