Forms :: Linking Two Unrelated Subforms To Main Form
Feb 5, 2014
I am trying to link two unrelated sub forms to a main form so I am able to query data all at once and make a report that displays all this data at once. I do not know if this is possible. I will tell you to the best of my ability about what I have going on.
My main form is a shift report. The primary key is a auto number ID. The rest of the fields are date, name, shift, vehicle. etc.
The first sub form is area attendance. Field are as follows auto number ID (primary key), report ID(which comes from the main form, linked), the area, and the area attendance.
The second sub form is the event log. Fields are as follows auto number ID (primary key), report ID(which comes from the main form, linked), time in, and events.
My relationship now is simply primary key from the shift report (the autonumber) going to the first and second subforms report ID's.
Problem is I can not query two distinct subforms like this (I realized).
I have a main form with a combo which lists all forms in my database. There is also a button which open all the forms depending on this which I will choose from my combo.
Private Sub Command2_Click() DoCmd.OpenForm Me.cmbforms End Sub
Is there any way to open the forms in a subform in my main form?
I have created a database in microsoft access 2010 to show invoices for different customers in different countries. In doing so, I created using a two subforms in a main form. I have used the "country name" to link the subforms to the main form. When I enter new records into the subforms for a specific country, I realized that a duplicate record of an old record are being created in the subforms. What can I do to prevent this from happening? I tried to change the query link between the main form and subform to "invoice number" but the same problem has occurred.
I have a main form with multpile tabs - each tab containing a different subform.
Link Master Field: ClientID (field in Master Form) Link Child Field: Client ID (field in all subforms)
There is another field that all the subforms (continuous type) have: ObligorName. All the subforms are based off of a huge table (subtable) with fields: Obligor Name, Address, Zipcode, City, DOcuments Required, Bank Account Number, etc......
Essentially, the user will fill in the 10 obligor names associated to ONE client on the first subform on the first tab + address + zip code + city.
When the user clicks on the second tab to fill out the next subform, I want all 10 obligor names to be there already, so then they can fill out Documents Required + BAnk Account Number.
If I fill out the first subform and then exit out of the form and then reopen it, the other subforms autofill.
HOWEVER, I dont want to have the user have to do this. It wastes a lot of time. What can I do about this so that the table is automatically updated right away. They are all based on the same table so I do not see why there is so many issues.
I have a main form "frmDriverNoticeRecord" with 2 subforms, "frmSubDriverNotice" and "frmSubVehicleRecord"..The main form uses "IncidentID" as the PK. Each form stores data in its own table. The tables are related via IncidentID and there is a 1-many relationship between tblIncident (main) and tblDN (sub) and tblVehicle (sub).
I have a form "frmIncidentLog" displaying records in a table view with a few fields for quick reference and to allow selection of a single record for detailed viewing. I created a command button with the intent to open the "frmDriverNoticeRecord" at the current record. The main form and child link fields appear to be linked correctly; i.e. IncidentID on all three. If I open the form manually it opens and I can use it and search and filter as I want. If I try to open it via the command button It opens a small window asking for the IncidenID, when I enter theIncidentID number, it opens the form to the first record every time.Here is the code:
Private Sub comOpenDR_Click()
Dim frmName As String Dim recID As String frmName = "frmDriverNoticeRecord" recID = "[IncidentID]=" & Me![IncidentID] DoCmd.OpenForm frmName, , , recID End Sub
I tried running the the DoCmd.OpenForm command directly from the button using the where condition (in various manners) with the same results.
I am attempting to create a patient tracking database for a clinic I work in and I am stuck at one small but major part.
I have a parent form called frm_Patient_index. On this form you can enter patient details such as personal details, observations ect. I need to create a lab request form for certain tests to be performed.
I want so that a button on the frm_patient_index form opens a subform where the relevent tests can be requested via tick boxes. Now here is my problem I have managed to create all of that except for the information to be entered into the frm_lab_request automatically and get SAVED to its corresponding table. It will not save for me.
I can get the information such as Badge Number, First Name, Surname and DOB to all enter into the fields automatically but getting them to save to the table is not happening.
I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form.
i have a stock control db. when new stock is ordered it updates 'units on orders' field, then when goods are recieved the subform field is updated and this automatically updates the 'units on hand field'.
i then have another subform for stock going in and out, i would like to be able to have the units on hand field as above (which is the main form) automatically updated like is when using the the goods recieved sub form??
not sure if i explained it properly but i can send the structure if that helps?
I use Access 2003 and have created a form with several subforms which I've placed onto a number of tabs. I'd like to have some of the most recently entered data from the subforms displayed on the main form.
For instance - if one of the subforms details the repairs to my car, in terms of date, items repaired, name of the mechanic and the cost, I'd like the most recent date of repair to be displayed on the main form. I know that I can see it be clicking the "Car Repairs" tab then scrolling down the information, but I'd like to have it displayed for easy viewing. I'm not sure if I'd need to have some VBA to do this or if it can be achieved by, for instance, creating a query to populate the appropriate textbox on the main form.
I have two subforms. They are in nice neat grids as access setup for me. Both of these forms should have similar data, based on a upc. What I need to do is turn the text of an entire row to red when there is no matching upc in the other subform. The two problems I cannot figure out is as follows.
1. How can I access the forecolor property of a text box in a subform from the main form?
2. How do I access only one row of data, in the default grid?
I’m hoping someone can help a very confused newbie :confused:
While I have knowledge in using MSAccess I can honestly say I am well and truly stuck. I have searched the forum, but cannot find anything to help me out … if there is anything I am sorry for re-posting. While there may be helpful responses, they mostly involve code, which I do not know.
I have a Main Form (frmPreApprovedTravel) and numerous Subforms (sfrmFlightRail, sfrmHotel, etc). I have designed my Main Form with tabs and each tab contains staff details, flight, hotel, taxi, etc information.
My problem is that when I go to the next record in my Main Form I want the Subforms (all of them) to go to the next record as well. I know this is possible but having tried to figure it out myself for the last 2 hours, but know I’m still missing something!
I would appreciate any help and thank you in advance for the help and taking the time to read my problem.
My main form was working fine (I could key in data) until I added two subforms. Now the main form will not accept data, but the two sub forms do accept data. I have searched properties of all forms and queries, and I cannot find any suspects.
I have a main form and four subforms all of which were created from the tables without queries. The main form pulls employees personal data (never changes). The subforms pull Events attended, Lodging at the event, Family that attended the event and Employee minutia which changes per event. I'd like to have a button on the main form that changes the records in view for all of the subforms at once. This way it is easier for the users and I know that I am view all the pertainent info for event A instead of viewing event A's lodging info with event B's family info.
I have a form linked to a subform by an activity field, Both have a UID field also. I want to store the UID from the main form in each record in the subform. How do I link the two? I've done it before but cannot remember how and have been trying now for AGES! Any help would be much appreciated :)
I have an access form (Customer) along with a sub-form (Work_done). On sub-form I have Running sum of Amount in Text box-1. I want that Total of Running sum be replaced with Main form's tables field total_amount. Is it possible that we can replace an amount of control of sub-form into main form's field?
I have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be able to press a button and have the second tables form pop up and add that that specific Project_Number. I added the button and went through the wizard process. I then added the linking info through the builder. It works fine if there is already data entered for the project_number in that specific field. but if the field is empty, the popup window doesn't recognize a project_number and doesn't add it to that record. below is what I am using. The project_number in the 'main' table is text and the Project_Number in the 2nd table in a number since it is a lookup field.
Private Sub CongressionalDistrictCmd_Click() On Error GoTo Err_CongressionalDistrictCmd_Click Dim stDocName As String
Go to frmInvoice, and you'll see a Net Total box (txtNetTotal) . It's control source is linked to a textbox in the subform fsubInvoiceDetails2 called txtStocktotal. It basically just pulls up all the costs associated with that InvoiceID.
The reference mechanism is as follows: =[fsubInvoiceDetails2].[Form]![txtStockTotal].Now...sometimes this works and sometimes it doesn't! Sometimes i've had to use: =forms!fsubInvoiceDetails2!txtStockTotal.
It seems to be very temperamental at times and i'm not fully confident if this can be explained.By way of note, I use express builder normally to input these statements: I go to Forms > ALL FORMS > fsubInvoiceDetails2 > txtstocktotal.
I have a table called Contact. A contact can be in the db by itself, or it can be tied to a member, or it can be tied to a facilitator or it can be a member AND a facilitator.
So I have a contact Form with all the contact related data and 2 buttons on it. One for Member and one for Facilitator. Each button should load the corresponding form. If the contact is a member (data is already in the member table for the same contactOID) then the form should populate with that information. If the contact is NOT a member, the form should be blank.
But what if I want to add a Contact record, and then add a Member record (tied to that same contact record through contactOID). I would like to be able to open Contact, click create new (>*) and enter the info. Then hit the Member form and enter all the Member info. However, when I do this I get this error:
You cannot add or change a record because a related record is required in table 'Contact'.
That doesn't make sense, since there is a record in Contact (I just created it). Do I not have the forms or tables linked correctly? Currently the Member table is linked to the Contact table through contactOID (PK in Contact - Autonumber) and there is referential integrity enforced on the relationship.
I’m truly sorry about posting a question that probably should be found by searching this forum. However, despite some ambitious, but not very fruitful, efforts to locate answers to it, I’ve decided to start this thread anyway.
I’ve used a sample database to create a contact database. The sample database contains a table called “Samtal” (which in English should translate into something like “calls”). The idea is that every contact in the database has a 1:N relation to the samtal table. It means that the user continuously can update the Samtal table for every phone call made to different contacts.
Every contact has a unique contact ID, which links the two mentioned tables together. Every entry in the Samtal table has a unique Samtal-ID (called “samtalsnummer”) as a primary key.
In order to easily access, administer, create and modify different entries in the Samtal table, the form “Kontakter” contains a button called “Anrop”. Clicking on this button, a new form, “Samtal” opens (taking the contact number as input from the active contact in the form from which the button was pressed).
The Samtal form contains two subforms (“underformulär” in Swedish): 1. Listing all the entries that are found in the Samtal table for the active contact’s contact number.(samtaslista underformulär) 2. Stating the content of the phone call. (samtal underformulär)
Very conveniently, the user can scroll through the list (in the first subform) and by picking/marking a certain entry, be able to see the content of the particular call (in the second subform).
My idea was basically to copy the Samtal table’s and form’s architectures to create a table for addresses, and in this way be able to assign every contact an arbitrary amount of addresses (and in this way keep track of old addresses as well).
After have done this, and even added an “Adress”-button in the Kontakter form. (Note that every address entry is to be assigned an “address type” collected from a predefined table called adresstyper.) Somehow, however, I can’t get it work at all. Gatuadress (Street address), Husnummer (Street number), Postnummer (Zip code) and the other fields found in the second subform (“adresser underformulär”) aren’t working.
My simple question is why it isn’t.
Any ideas, literature suggestions or comments are highly appreciated as I’ve been struggling with this for over two weeks. I’m attaching the database to this post.
I am sorry if similar questions have been asked by others but my understanding of subforms isn't good enough to apply other answers to my problems.
Essentially I have two problems. My situation is that I have a form with 4 tabs. Two of these are just straightforward tabs which have certain fields that must be completed. Originally I only had two tabs and then you would click on a button to open a different form. Before opening it qould test that the key fields had been completed and then open the form. I have now added this to the original form as a subform for the third tab. I suspect it may be rather obvious but I don't know how to apply the same logic so that I cannot switch to this tab until the key fields in the previous two tabs have been completed.
My second problem has to do with my understanding of how subforms link I think. My fourth tab is also a linked subform. When I have data in the first two tabs this form is visible but when there is not data this form is not visible. Why might this happen with this subform but not with the subform on the third tab which is currently always visible regardless of the data?
I hope this is clear but if it's too abstract please let me know.
What is the simplest way of linking two subforms so that selecting a record in one subform will result in specific related records in the other subform?
THe subform where the initial record will be selected is linked to the main form but the other is not and has no fields in common with the main form.
I do have some VBA experience, although it has been a while.
We are a theatre company attempting to link our bookings and contacts tables in a form - subform which can be viewed in chronological date order. We are having trouble establishing a one (contacts) to many (events) relationship and setting up the forms as such. What are some easy steps to ensure that both forms are visible, functional, and appear in the order we require? As of now, we only have the two separate forms built (along with the corresponding tables). The relationship field, we presume, is the organization contact itself, and the main form would be the events with the contact appearing as a subform at the bottom of the page.
I tried searching for an answer, but with no luck. My problem is with linking master/child forms. What I want the subform to do is to show me a list of records that have the same "GroupID" as the master form. To do that I set the link properties to:
Link Master Fields = "GroupID" Link Child Fields = "GroupID"
This works perfectly fine! Now I wanted to take it a step further and add another link so now I have this:
Link Master Fields = "GroupID;LastName" Link Child Fields = "GroupID;LastName"
Now what (I figured) Access does is show me the records where the "GroupID fields match AND where the LastName fields match". But what I really wanted was that it displays the records where the "GroupID fields match OR where the LastName fields match".
