How to display multiple subforms on a single form

Posted on 2009-05-02
Last Modified: 2013-11-28
I think my relationships are okay but my question is about what I'm doing wrong or how to accomplish what I'm trying to do:

I want to show the details of an employment job, however, I want to show the various business entities associated with any given employer, such as the corporation headquarters, another name my employer was doing business under, or the conglomerate headquarters or to whom my employer was leased to.

That being said, I want to show the various phone numbers and fax numbers associated with  each business entity. The prospective employer needs to have all of this information available for confirmation and investigation.

What I'm having difficulty with is displaying all of the data on a master form. Is this even possible? And, if it is, can I edit all of the data on one main form?

If I'm opening up a huge can of worms, here, just let me know. Some insight and clarification would be most appreciated.

I want all table fields on one form, but Access is not letting me. I've tried numerous queries but with no luck.

How do I achieve the net result here in a broad description?
Question by:9XqUwH3S
    LVL 84

    Accepted Solution

    First build a form the shows all the data form tblBusinessEntity; on THAT form, include two subforms that will show the Phone and Fax information (although why you broke out Fax from tblPhone isn't clear).

    Now build a form that shows information from tblEmployer.

    In design view, drag the first form and drop it on the second form ... Access should relate them correctly, but if not check the Master/Child links and make sure they're set to EmployerID ... now, as you navigate records on the Employer form, your subform (based on tblBusinessEntity) should cycle through and show those records related to tblEmployer, and your tblPhone and tblFax records (which would then be a sub-sub form of tblEmployer) should show the correct records.

    Author Closing Comment

    That is exactly the kind of answer I was looking for. Great!
    Thank you! It works beautifully.Solved.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    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…

    729 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

    23 Experts available now in Live!

    Get 1:1 Help Now