?
Solved

Forms, tabular subform, tabular subsubform

Posted on 2007-03-22
7
Medium Priority
?
421 Views
Last Modified: 2013-11-28
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
Comment
Question by:dewster1971
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 14

Expert Comment

by:Glenn_Moore
ID: 18772407
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
 

Author Comment

by:dewster1971
ID: 18772502
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18790046
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Accepted Solution

by:
dewster1971 earned 0 total points
ID: 18836467
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
 

Author Comment

by:dewster1971
ID: 18836572
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18837949
dewster1971:

"Tabular" versus "Tabbed"

Didn't catch that.
:O

Gald you got it worked out yourself!
:)

Jeff Coachman
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

765 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