Access 2016 Adding third subform and would like to be able to show on invoice

Posted on 2018-01-13
Low Priority
Last Modified: 2018-01-14
I have a form setup to allow for Product, Service and Other. Three Sub forms. I would like to be able to create a invoice that shows the three sub forms. I used the following in the past to display two. IIf([IsProductCode],"Product","Service" What do I need to change this to to show all three?
Question by:Bill MacDonald
LVL 52

Expert Comment

by:Gustav Brock
Only you know if, how, why, or when either of the subforms or a combination of these or all should be displayed.
LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
On this:


 What your saying right now is if "IsProductCode" is true, then it's a product.   If it's false, it's a service.

 So the question is, what tells you that it's "other"?    If nothing, then you'll need to add something to indicate that.  What I would do is change "IsProductCode" from a True/False to a single character text field, with either P, S, or O in it.


Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

579 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