Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Forms, tabular subform, tabular subsubform

Posted on 2007-03-22
7
Medium Priority
?
428 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
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!

 

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 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