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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

Forms, tabular subform, tabular subsubform

I have a billing form with a single client for all items on the billing form.  On that billing form there are several invoices (kind of like a packing slip).  I use a tabular subform linked on the customer ID#.  That all works like a charm.  I also have another set of data that can have multiple results for one invoice on that billing item.  Ideally, I would like to have a tabular subsubform, in the tabular subform, in the main form.  For example, ABC co (Client- bililng form), orders widgets ( subform), these widgets come in several colors (subsubform).

Problem - Access doesn't like me to put a tabular subform in a tabular subform.  Is there something I can do here that will allow me to link the tabular subforms rather than inbed within each other?

Thanks
0
dewster1971
Asked:
dewster1971
  • 3
  • 2
1 Solution
 
Glenn_MooreCommented:
You can create subreports within reports.  Can you create a new report with Client billing form, orders, widget colors and tabluate in a 4th subreport?
0
 
dewster1971Author Commented:
Admitedly, I haven't done much with reports but have instead run things through forms.  I would prefer to use a form since I'm more familiar with them and have several macros and links set up with this existing form.
0
 
Jeffrey CoachmanCommented:
dewster1971 ,

<Problem - Access doesn't like me to put a tabular subform in a tabular subform. >

Problem?...  I did this a while ago, and it work just fine AFAIC.

(Customers-->Orders-->OrderDetails)

https://filedb.experts-exchange.com/incoming/ee-stuff/2977-Access-TabbedSubForms.zip

Is this what you wanted?

Jeff Coachman
0
Industry Leaders: 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!

 
dewster1971Author Commented:
This was resolved by creating multiple queries which corresponded to each individual line on the form (6 queries).  The information was then pulled via text boxes onto the form.  

0
 
dewster1971Author Commented:
boag2000 -

This is not what I was looking for.  I wanted to place a continuous form within a continuous form (aka tabular form).  You showed a good example of a tabbed form.

very different.

Thanks
0
 
Jeffrey CoachmanCommented:
dewster1971:

"Tabular" versus "Tabbed"

Didn't catch that.
:O

Gald you got it worked out yourself!
:)

Jeff Coachman
0

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!

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