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

Bill MacDonald
Bill MacDonald used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Only you know if, how, why, or when either of the subforms or a combination of these or all should be displayed.
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
On this:

IIf([IsProductCode],"Product","Service"

 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.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial