Solved

Insert Statement when using a subfor

Posted on 2015-01-07
7
77 Views
Last Modified: 2015-01-12
Can I use a Insert statement for fields in the Main form and the sub form??
0
Comment
Question by:Jass Saini
[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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 84
ID: 40536258
What do you mean - you want to INSERT data into a record, and then show it via a Main form and Subform?

Or you want to take data from a Main form and Subform and INSERT that data somewhere?
0
 

Author Comment

by:Jass Saini
ID: 40536399
Take the data from a Main form and subform and insert into a table
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 40536475
Generally you would take the data from the underlying table of the form/subform and insert into another table.  Can you provide a sample of what you are trying to accomplish.

ET
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40536492
Then lets drop the term "Insert Statement"
...and just say: "Take the data from a Main form and subform and insert into a table "

When you specify "Insert Statement", ...you seem to be specifying the exact technology (SQL *Insert statements*, in his case) that you want us to uses, ...despite the fact that there may be other ways to accomplish this...

That all being said, ...I have to ask why you need to do this...?
The very nature of a one to many relationship is to avoid having one table with two different sets of data, ...not to mention the fact that if you do this, you would would create redundant data, (that would need a mechanism for being updated when the source data changes)

The typical way of dealing with this is to make a query joining both of your tables.


So you may wish to restate your ultimate need here, ...then experts can recommended the best way to accomplish this...

JeffCoachman
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 40536514
Here is a sample of a *query* that displays mainform/subform (Parent/Child) data.
(It can be filtered as well)
...but I think this addresses your question here as I understand it...
Database50.mdb
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 40536863
I agree, we need an example of what you are trying to accomplish as there's usually a little cleaner way without having to duplicate the same information in various tables.

ET
0
 

Author Closing Comment

by:Jass Saini
ID: 40544735
Thank You
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

738 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