473,837 Members | 1,669 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subform

158 New Member
While at it I have another one that has been bugging me to no extent:

I have a work order form,
this work order form has a subform called Work order details,
there is another form attach to that called Task,
and another called task Details,

I been trying to take Task, and Task Detail onto tab pages in order to have a cleaner desktop. any of you know how I can have my forms stay together following on the same ID number but on different pages?

** Admin Edit **
A better phrased version of this problem can be found at Post #4.
Oct 5 '09 #1
7 1851
NeoPa
32,584 Recognized Expert Moderator MVP
This question was split off from Time question, 6 years still no answer.....
Oct 5 '09 #2
NeoPa
32,584 Recognized Expert Moderator MVP
This is not very clearly explained. Are you saying you have a single main form (Work Order) and you'd like three separate subforms, all linked to the main form by a field called [ID] (You will have problems if you call your fields anything so ambiguous as [ID]) where each subform is in a separate page of a Tab control?
Oct 5 '09 #3
jaad
158 New Member
I have been using a master form with 3 subforms to keep track of my Work Orders. Lately I been feeling to clear some space on that very charged master form and put the 3 subforms on a tab page of their own to make things clearer.

This is the way the form is set up:

I have a master form with a combo box that filters out my customers with only active work orders.

In turn this combo box updates my subforms that are:

Work Orders
Work Order Details
Tasks
Task detail

These form used to work fine when they were all on the same form and nested within one another. since I separated them to have their own individual page on a tab control I get a parameter error message about my Work Order Detail form (which feeds my Task and task details form)

The link parent and child field are as follow:

[Main form] and [work order form]use the Customer ID as link
the [work order form] and [work order details form] use Work order ID as Link
The [Work order details form] and [task form] use work order detail ID as Link
the [task form] and [task detail form] use task ID as link

I know this is pretty simple to fix but I can't seem to have it work.

I tried putting each ID field on the detail area of the main form and it worked for a while but then suddently Access started to crawl slow as a turtle....

is there a quick fix to this?
thanks
Oct 11 '09 #4
jaad
158 New Member
Sorry I am going to try to fix how the question appeared. I'm learning the ropes of this site too. stand by.
Oct 12 '09 #5
NeoPa
32,584 Recognized Expert Moderator MVP
That's fair enough.

You will almost certainly be unable to fix the original post as the time to edit has passed. However, it is perfectly permissable to post it again as a reply and just state clearly that it replaces the original question. We can work with that.
Oct 12 '09 #6
Denburt
1,356 Recognized Expert Top Contributor
From what I think you are saying you should have some way of distinguishing between each item so you don't get all the info from each one.

Work Orders
Work Order Details
Tasks
Task detail

A work order for instance would have a name or number that I would look for then the work order details would contain various tasks that need to get done. So I would define a distinguishing name or number for each task, this would allow you to filter things down to the task details that need to be handled. This would allow you to use a combo box or such so you can filter it down to the task detail you need... Do you think this may help resolve your issue?
Oct 13 '09 #7
NeoPa
32,584 Recognized Expert Moderator MVP
I meant to post the question in here Jaad. Simply reposting it (as a separate thread) is not recommended. It's actually against our rules.

I assume you were simply trying to follow instructions but got it a little wrong. That way you get by without a warning (We'll forget about the time inconsistency for this one).

I've merged the threads now (as you'll have seen).
Oct 13 '09 #8

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

Similar topics

15
24901
by: Rey | last post by:
Howdy all. Appreciate your help with several problems I'm having: I'm trying to determine if the Visit subform (subformVisits) has a new record or been changed, i.e. dirty. The form that contains the subform is named Clients. I have this code in the Add Client btn: If Forms!Clients.subformVisits!VisitDirty = True Then MsgBox "Visit subform is dirty!"
25
10284
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the data in each record, which includes the ID of the father and the mother (who also have records in the table). One record per form. I have a Tab Control in the form, and in one of the tabs I have a subform (sfmSiblings) in which I wish to list...
1
8525
by: John Michael | last post by:
I have a form that has a subform that has a subform. The subform loads a record based on a combo lookup box in the main form. I'm trying to set a value in the subform based on a value in a subform of the subform. the main Form is called Subform is called Subform in the subform is called
4
7026
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the user enters the last qualifying field on the main form. In one case this works fine, the subform shows the data the user wants to update -- which means showing all the data put in previously (ie showing this via the requery and the continuous...
1
3043
by: MP | last post by:
I have a main form that has a subform which also has a subform: the main form is the first subform is the second subform is When I click on the button »AddNewSubSubRecord« (add a new record in the second subform , the code generates the message: Can't find the field »POG-03 Work Subform« reffrred to in your expression.
9
9719
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a master-child link to the first subform. subform2 - Master Field: subTrainingModule.Form!TrainingModuleTopicSK Child Field: TrainingModuleTopicSK
6
5994
by: DMUM via AccessMonster.com | last post by:
Hello I am trying to pass the name of my subform to a function/sub but I can't seem to get it to work. I am using an autokey function (ctrl E) to unlock text boxes on a subform. I have a few forms in the database that will use this function, so I need to be able to tell the code which form to unlock. What I have is as follows: Public Function akeyEdit()
4
8868
by: Macbane | last post by:
Hi, I have a 'main' form called frmIssues which has a subform control (named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs. A control button on the main form opens a pop-up form which allows me to edit the record in the subform. What I want to happen is for subform with the new edits to be updated on the main form when I close the popup. I'm sure this is a very small bit of code in the the 'On close' event for the popup...
7
12316
by: ApexData | last post by:
I am using the following code in my TabControl to manage subform loads. The code assigns the subForms SourceObject. - Do I also need code to DeAssign the SourceObject when leaving the Tab, I'm thinking the Table will stay open otherwise ??? - Do I also need to use code to Assign the Child&Master Links, or can I just type the names into the subForms Control Property and just depend on the SourceObject to link to Table???
5
4907
by: samdev | last post by:
I have created two combo boxes in a subform.... For example 1. Combo Box State 2. Combo Box City 3. When a state from the Combo Box State is selected, the City combo box updates to reflect the State chosen by only showing cities in that selected state. 4. When I open just the subform it works just fine but when I open the
0
9846
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9685
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10886
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10277
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7007
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5674
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5853
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4479
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3126
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.