[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 660
  • Last Modified:

How to display multiple subforms on a single form

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?
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
9XqUwH3SAuthor Commented:
That is exactly the kind of answer I was looking for. Great!
Thank you! It works beautifully.Solved.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now