473,378 Members | 1,364 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Question about multiple instances of a subform

I have a database where I'm trying to do some root cause analysis on design changes. Each design change could have multiple root causes associated to the change. I'd like to try to setup the data entry form into a section that has the base information about the design change (ID, person responsible, date issued, etc.) and then have a linked subform for the root cause (type, error origination, etc).

I know how to setup the form (frm_main) to have a linked subform (frm_rootcause) in it, but I'm not sure how to go about allowing multiple copies of the subform to be open. I'd like to have the instances of the subforms open within the window of frm_main.

Is there a way to have frm_main display the base information and then have a button that will automatically add copies of the subform to the bottom of frm_main and each of those copies be a single root cause?

Thanks,
Sarah
May 24 '07 #1
3 2731
MMcCarthy
14,534 Expert Mod 8TB
I have a database where I'm trying to do some root cause analysis on design changes. Each design change could have multiple root causes associated to the change. I'd like to try to setup the data entry form into a section that has the base information about the design change (ID, person responsible, date issued, etc.) and then have a linked subform for the root cause (type, error origination, etc).

I know how to setup the form (frm_main) to have a linked subform (frm_rootcause) in it, but I'm not sure how to go about allowing multiple copies of the subform to be open. I'd like to have the instances of the subforms open within the window of frm_main.

Is there a way to have frm_main display the base information and then have a button that will automatically add copies of the subform to the bottom of frm_main and each of those copies be a single root cause?

Thanks,
Sarah
I wouldn't advise you to even try it :D Why not just use a continuous form?
May 26 '07 #2
I wouldn't advise you to even try it :D Why not just use a continuous form?
Do you mean using the subform as a continuous form and have it automatically link to the base information? I want to make sure the multiple root cause categories are all linked to one change request.
May 30 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Do you mean using the subform as a continuous form and have it automatically link to the base information? I want to make sure the multiple root cause categories are all linked to one change request.
I'm not sure I understand. Please remember I can't see your database.

Is your subform bound to your main form?

What do you mean by link to base information?

If your subform is based on the root cause categories and your main form is based on the change requests then I don't see the problem.
May 30 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: J. Black | last post by:
Hello everyone - I've been developing an incident tracking and reporting system for an emergency services outfit that I work with part time. It's going well, except for one fly in the ointment....
5
by: John Winterbottom | last post by:
Some time ago Steve Jorgenson, (I think it was he), wrote of possible problems using the intellisense-friendly "Form_" syntax to refer to forms and their controls. At the time I responded that I'd...
3
by: Lenny Fincher | last post by:
I have a form with a subform. I want to allow multiple subform records to be selected and processed. I am using selheight and seltop to determine which records to process. No matter how many...
4
by: Mason | last post by:
This is probably an incredibly newbie-ish question. I just haven't had the cause to use many subforms before, so I'm pretty sure I just don't understand it correctly (even after reading up on it)....
0
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main...
2
by: raskovsky | last post by:
Hello, I'm new to access, I've used vc++ and sql, but I was required to program this project in access. I have two questions in one. First let me explain my program. It's a huge database which...
7
by: scottgamble | last post by:
My company is making the switch to DB2 from Oracle. I have been working with Oracle for the last 10 years or so and still very very new to DB2. One question that has come up recently within our...
3
by: nicholas.petrella | last post by:
I am currently trying to use the python logging system as a core enterprise level logging solution for our development and production environments. The rotating file handler seems to be what I...
0
by: Chris O | last post by:
"Larry Lowe" <llowejr@usa.netwrote in message news:ad17577.0308140714.1b14d778@posting.google.com... Hi Larry. Some responses aren't very helpful. I'll try to do a little better. The first...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.