Access Link Subform To Another Subform

Choose the Linking Field. Activate it and execute it. Discuss forms that have multiple tabs with subforms bound to each tab 2. AutoFill in Subform - Access 2003 Alright, here's the problem. And what are the types in Excel and Access subform? Refer to this link to check: Excel and Access. Subform1 is the name of the subform CONTROL on mainform. A subform is a datasheet form that displays linked records in a table-like format. Referring to Controls on a Subform Sooner or later, you will need to refer to information in a control on another form - a subform, the parent form, or some other form altogether. Re: Link from a Field in One SubForm to Another SubForm (Already Opened) Generally if child (subform) is linked to parent (main form) then you are linked. first subform, I want the second subform to display the list of all students enrolled in the class along with a Yes/No checkbox that can be clicked to indicate that the student attended the selected session. That form is embedded into the main form, and Access will automatically add the ID number from the main record to all of the records in the sub-table. " field from an article which is active on the main form from the code in the subform. , the outer repeating subform), which I then coded, — the problem seemed to go away for me. Access 2003 Forms Use the Form Wizard to Create a Form and Subform Search MS Office A-Z | Search Web Pages/ Design A-Z Use the Form Wizard to Create a Form and Subform. It's not pretty, but I've done this with a task management database to display the completion percent and such. Forms: Refer to Form and Subform properties and controls. Using DoCmd. Save the state from becoming another Michigan. Access gives focus to. Progress Notes - Copy in the file and indexed. Specify the name of the form you want to display when the user hovers over the comfill in the Subform Format field. Nonprofit Technology Chat: Access Subform problem. LinkChildFields property (Access) 03/26/2019; 2 minutes to read +1; In this article. Hi people that are smarter than me (I know there's lots of you here!) I'm trying to requery a combo. So then you can filter the second subform's recordsource by the first subform link value Then requery the second subform on the first subform's current event. If you are going to use a subform for this you may want to look at the child and parent properties that are used to synchronise a parent and a subform. In the main form’s navigation bar click the Next Record button three times (or edit the specific record field to 4 and press ENTER) to go to the Around the Horn customer record. Subform controls allow for the creation of linked table-like displays of information that are related to the main topic of the form. Change it to [Forms]![frmMachineSpecs]![frmSpecs]. If a subform control has the focus, this method only requeries the record source for the subform, not the parent form. When I try the form, clicking on different rows in the listbox, it says in the status bar it is calculating, but all I get in the subform. (Is this correct?) Your problem, as I understand it, is that Access identifies subforms as just another control, so it's ability to do things directly with subform. Make sure you have the subform selected, not the form within the subform. In the students form, as you move from row to row in the subform of courses for which the student is registered, the second subform shows the attendances by the student at sessions of the course in question. For example, you could place a hidden textbox on the main form referencing the textbox in subform #1. There needs to be a field that links the main form and its subform. This automatically includes the data of the MainForm in one tab and also the related SubForm data in another separate tab within the same excel sheet. It is generally used whenever you want to display data from multiple tables where there is a one-to-many relationship. changing focus from control on one subform to control on another subform I have a main form (TABS-2) that resides on the first tab of a tab control. To create another record from the standard list view, click the Subform element and a new record will open. Alternatively have a look at the filter property that you could use. The record link id column generated for the MainForm report can be used to refer the related SubForm entries. The form and subform concept can be illustrated with the "Company-Product" example. The properties for the comfill appear in the properties view. The reason we have gone to the trouble of creating the subform link is to enhance the user friendliness of the database application. form and controlling the hide-when formula to show the subform. Before that you must needs to have complete knowledge on what this subform is actually. Subform2 is the name of the subform CONTROL on the 1st subform. Set the Link Child Fields property and the Link Master Fields property of the subform to the name of the field or fields that are used to link the tables. A subform is a form that is inserted in another form. We will link the subform to the main form in a few minutes, by means of an SQL query with a named parameter. If trigger is '1', then it will trigger first master page. Although technically a control, subforms have some form characteristics as well. Progress Notes - Copy in the file and indexed. Click to download: S ubform Shrink & Grow v2. Subforms displayed on forms have full functionality. 2) On another page of TabCtl0, create a subform control named 'sFrm2'. 4 Linking forms and subforms manually If both the form and the subform are based on tables, and if relationships have been defined between the tables, Access normally has no problem determining which fields “link” the information on the main form with the information in the subform. I need help specifically on how to call the Filtering method I have established in the dependant subform from the presidential subform. Now right click on the top edge of the subform and from the pop up menu that appears select 'Properties' The properties to note here are. An Alternative to Multiple Subforms in Design View for Faster Load Times In this video we will: 1. Then move on up to re-creating each and every other little nook and cranny and hamlet in backwater California. The subform contains data that is relevant to the the data in the main form. I have 2 subforms on a main form. If attribute multiple is set to true then the included form will be repeatable. Otherwise, the wrong data could be displayed or edited by the user. changing focus from control on one subform to control on another subform I have a main form (TABS-2) that resides on the first tab of a tab control. About subforms. Now right click on the top edge of the subform and from the pop up menu that appears select 'Properties' The properties to note here are. Form![Control Name]. Set the Link Child Fields property and the Link Master Fields property of the subform to the name of the field or fields that are used to link the tables. Beginning Access Database Subforms What are MS Access subforms? The best way to think of a subform is a form within another form. In your subform properties look for Link Master Fields and Link Child Fields properties. depending on the user's selection, instead of putting all the subforms into the. Refer to the following sections to learn about subforms: Appearance When to use this field Adding a subform Features Appearance. When an item is selected, the related subform should come up (i. (static data, cannot edit). It is generally used whenever you want to display data from multiple tables where there is a one-to-many relationship. If you created a form from a table whose records are linked to another table, your form probably includes a subform. A ccess lets you display data that is related to records in a form or report by using a subform or subreport. 1) How do i access datafields of the mainform from within a subform ? I want to get the "Nr. Changing subform "Source Object" property with VBA by Zm91cnN0cm9rZQ » Wed, 11 Aug 2004 17:35:01 GMT I want to open/activate a different subform based on the value of a combo box in the main form. Set the LinkChildFields and LinkMasterFields properties of the subform control to keep the subform in sync with the main form. Subform controls allow for the creation of linked table-like displays of information that are related to the main topic of the form. Similarly, in the courses form as you move from row to row in the course sessions subform, the students attending the session are shown in. If using a Multi-Paging Subform with the Separate Table View, and you want to add another Subform record, click the + icon in the upper right-hand corner. To verify that the linking was successful, on the Home tab, in the Views group, click View , click Form View , and then use the main form's record selector to advance through several records. If the user clicks another session in the first subform, the list in the second subform again. MS Access: Subforms. Re: open subform with button Brian: I want to take this opportunity to thank you again for sticking with me. Note that this form/subform has three navigation bars: one below each of the two subforms and another one at the bottom of the window for the main form. Also I do not want to create another record that is the same. com Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads. In this movie, Adam creates two subforms inside of a tab object that display records related to the products sold at H+ Sport. NET, INFO, MemberID, Tables, Box, and Subform. It was originally written in response to a question by Access World Forums member psych0tic1 in this thread: Another Visible/Hidden Form Field Question. Linking the sub-subform Given the restrictions of Access, I set up a senior and a junior subform, both linked in a master-child relationship to the Level 1 Trip form. Hi All, I am looking for if it is possible to create a structure similar to the access subforms, to have multiple product records for a purchase order, or another concept that could work in the same way. An Alternative to Multiple Subforms in Design View for Faster Load Times In this video we will: 1. Then set sf2's Link Master Fields property to txtLink and the Link Child Fields property to. What we're considering is how the subforms should reference the Master. Hi people that are smarter than me (I know there's lots of you here!) I'm trying to requery a combo. You can create one or more subforms that collect information for a sub-table on the MANY side of a relationship to the table underlying your main form. When you open up the 'Issues List' form, and click on an ID, it behaves like a hyperlink and opens up that record in another form. In this case, we'll open the form called Orders. Subforms displayed as pop-ups are read-only; users cannot interact with them. Also I do not want to create another record that is the same. I need help specifically on how to call the Filtering method I have established in the dependant subform from the presidential subform. This works to set the focus on a field in the first subform: [code]Forms!frm_Main!frm_SubFor Setting Focus on a subform - Microsoft: Access Modules (VBA Coding) - Tek-Tips. In this video I further explain why the calculation in the main form has to be. If a subform control has the focus, this method only requeries the record source for the subform, not the parent form. Discuss forms that have multiple tabs with subforms bound to each tab 2. Subforms can contain the same elements as regular forms. You cannot put a. However, the simple filter cannot be used if the field you wish to filter on is not in the form. Access for Office 365 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More Less This article describes you how to add a text box control to an Access form, and then set the properties for that text box so that it displays a value from a control on another form. MS Access requery subform from another subform. Ideally I'd like to be able to add Guardians to Students using the subform (which is already working) but before creating a new Guardian record, the user should be forced to check that that Guardian hasn't already been entered under another student, and if so, they should link to the existing record. Status Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. For situations where the link master field is editable, a subform MUST be linked to the control rather than underlying field. To Access, a subform isn't a form at all, but a control, so you must reference it as such. form and controlling the hide-when formula to show the subform. To display the subform as a pop-up, use the Comfill control instead. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. Set each tect box visible property to false. Have a look here: Introduction to Recordstes in ADO and Using ADO in VB and Access. I currently have a form that contains a subform, which has 4 subforms in it. It is placed within a tab control in the parent form. Link subform to another subform keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. NET, INFO, MemberID, Tables, Box, and Subform. We tend to create our forms to show single pieces of information. The syntax of your sql statement is wrong. Choose the table or the query in the Properties window and set other parameters. Discuss how this can. I finally got it that when a button opens one subform, the rest of the lines of code for the button ensure that the other subforms are not visible. In Microsoft Access (MC) you can create a main form and then drag and drop a subform onto it and the application automatically knows how to pass the primary key from the mainform to the foreign key on the subform when a record is created. Do you know in Access using a table you can create a subform i. 2) A subform with a grid control bound to the linking table. MS Access: Items on drop down menu link to different subforms? Hi, I'd like to create a drop down menu with approx. AutoFill in Subform - Access 2003 Alright, here's the problem. A subform is a form that you position inside of another form. But before starting this let's have short info about subform is a form that is nested inside of another form. Beginning Access Database Subforms. If you are viewing the subform from the main form while in design view, must actually go into the container and select the subform to view its properties. Choose the Linking Field. depending on the user's selection, instead of putting all the subforms into the. -- S "Klatuu" wrote: > to link the subform data to the mainform data, use the Link Master/Child > fields properties of the subform controls. Might take another look at. Each subform represents one data view; that is, each subform control can have a single business view (BV) attached to it. Combo box showing unique artist list which, when the user chooses an artist, it updates the subform to show the list of songs by the artist. I need help specifically on how to call the Filtering method I have established in the dependant subform from the presidential subform. Subform controls allow for the creation of linked table-like displays of information that are related to the main topic of the form. Alternatively have a look at the filter property that you could use. With this feature you can present many related records in just one record. Access gives focus to. MS Access also allows the creation of Subform by dragging one form onto another and also allows design changes which can be accessed from the Design tab in Tools Group. Each subform represents one data view; that is, each subform control can have a single business view (BV) attached to it. So when pressed Address_Button, only subForm_Address will be visible on the MainForm. Choose the Linking Field. You will have to decide where to trigger the event. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT. I hope that helps. Transferring Focus Between a Main Form and its Subform. Using subforms. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT. When using VBA code to set the focus from a main form to a control on a subform, one calls the SetFocus method. This is how I'm using it: The main form: FamilyNameForm - includes all the shared info about a family, ie. Linking the sub-subform Given the restrictions of Access, I set up a senior and a junior subform, both linked in a master-child relationship to the Level 1 Trip form. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. TripReceiptSub is the senior subform and is linked to the main Trip form by TripID. In the two subforms scenario, the second subform is filtered on a value in the first subform. However, if you want to filter SubForm B according to the current Record in SubForm A then see UA Topic Referencing a subform field from a 2nd subform. If you created a form from a table whose records are linked to another table, your form probably includes a subform. Each time you change the value in subform #1, Access will automatically display the matching records in subform #2. records on one subform based on the record selected in the other subform. You cannot put a. To do this, add a hidden text box named txtLink to the main form's header/footer section. For this symmetric relation you can show the orders related to each item in the same way (main form of items, list box grid with orders). This is how I'm using it: The main form: FamilyNameForm - includes all the shared info about a family, ie. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT. AutoFill in Subform - Access 2003 Alright, here's the problem. In your subform properties look for Link Master Fields and Link Child Fields properties. Use this control to display a subform on another form. address, home phone, etc. And what are the types in Excel and Access subform? Refer to this link to check: Excel and Access. If attribute multiple is set to true then the included form will be repeatable. Subform control. 2) A subform with a grid control bound to the linking table. Have an Access form with a customer number, which links to subform by that number via data supplied by query with Name, address, phone#, etc. when user selects itemB, the subformB should show). Access: How to get subform to expand. You can use the LinkChildFields property (along with the LinkMasterFields property) to specify how Microsoft Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. Posted by grant-collinsworth on Aug 17 at 5:04 PM Mark as helpful. ) on a form. I am aware on how to create a parent form and link to a subform so that it shows data relating to the parent form record, but my question is this:. In the Northwind database, open the Tools menu and click Relationships. Form![txtOEM_No] This assumes that frmSpecs is the name *of the Subform control*, not just the name of the form within that control. MS Access requery subform from another subform. > Therefore, when I created a subform "Product History", I could not link it > directly to "Companies" form, in other words, Link Child Fields and Link > Master Fields is empty now. In that case, you may set the link properties dynamically. Set the LinkChildFields and LinkMasterFields properties of the subform control to keep the subform in sync with the main form. Microsoft Access 2007 One Form with Two Tables data, without using Subforms? I've self taught Access to myself for a month now, and I've hit a problem that likely stems from my misunderstanding the inner workings of Access. Discuss forms that have multiple tabs with subforms bound to each tab 2. You could probably toggle the subform's Default View from 'Single Form' to 'Continuous Form' as necessary to accommodate the user's display of data entry. Subforms can contain the same elements as regular forms. Select the subform button on the toolbox (as highlighted in the picture above) and click on a position on the form where you want the subform to be placed. CONTACT subForm and NOTEs SubForm will be non-Visible. If attribute multiple is set to true then the included form will be repeatable. What are MS Access subforms? The best way to think of a subform is a form within another form. Repeat this step to add any additional subforms to the main form. Beginning Access Database Subforms What are MS Access subforms? The best way to think of a subform is a form within another form. But before starting this let's have short info about subform is a form that is nested inside of another form. When an item is selected, the related subform should come up (i. Access will assume the Customer table fields should be placed in the new form because it is selected. Using DoCmd. I need help specifically on how to call the Filtering method I have established in the dependant subform from the presidential subform. The subform contains data that is relevant to the the data in the main form. A subform is a form that you position inside of another form. The value coming from the combo control is alpha, so when you concatenate it into the string you have to include the opening and closing quotes so that Access knows to treat it as alpha and not attempt to treat it as a number. Access uses the fields that relate the two tables as the linking fields. Ensure that the Field to store the parent ID is in the subform table, the on the main form (in design) select the subform and look at the properties. Forms are another way of describing screens. However, the simple filter cannot be used if the field you wish to filter on is not in the form. The simple answer is that you wouldn't use the subform to add a new record. com October 20, 2016 Post Author: OfficeTutes. Using DoCmd. MS Access - Forms, Subforms, Tabs What do I use to accomplish my task? If this is your first visit, be sure to check out the FAQ by clicking the link above. Just input away. I would like to make the subform auto expand/shrink (downwards) depending whether there are one or four records required to display. Discuss how this can. But before starting this let's have short info about subform is a form that is nested inside of another form. MS Access: Subforms. In this video I further explain why the calculation in the main form has to be. (Is this correct?) Your problem, as I understand it, is that Access identifies subforms as just another control, so it's ability to do things directly with subform. net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community , the registration is free and takes only one minute. Ask Question Asked 4 years, Access can be used as a means of simplifying Web development, and it's. A ccess lets you display data that is related to records in a form or report by using a subform or subreport. This is typically an ID field or similar. The main form or report is based on a table with a primary key, and the subform or subreport is based on a table or query that contains a field with the same name and the same or a compatible data type as the primary key. Access will automatically set LinkMasterFields and LinkChildFields if there is a relationship between the tables that the forms are based on and the fields are in each respective Record Source. MS Access requery subform from another subform. Re: Link from a Field in One SubForm to Another SubForm (Already Opened) Generally if child (subform) is linked to parent (main form) then you are linked. Rather than a button to open the > 3rd table, why not a sub form for the sub form?. Linking the sub-subform Given the restrictions of Access, I set up a senior and a junior subform, both linked in a master-child relationship to the Level 1 Trip form. For example, you might want to have a single subform control that changes the view based on which button on the parent form is pressed. You can actually do it using the second subform's Master Link Field property. Select the subform button on the toolbox (as highlighted in the picture above) and click on a position on the form where you want the subform to be placed. Before that you must needs to have complete knowledge on what this subform is actually. EXAMPLE: query has ID, HEADLINE, DATE, OWNER, SEVERITY This lists all the records. It shows the sum and total number of orders and payments as well as the balance due. The subform control is basically a window to let you view another form inside the main form. I hope that helps. Access-Diva provides custom databases using Microsoft Access utilizing SQL Server when called for. If you created a form from a table whose records are linked to another table, your form probably includes a subform. Hope it helps. Thus, it. A subform is a form that is inserted in another form. You would click the link to open that same record in its own form. If it is not possible, please tell me, but I had such marvelous luck with my first question, I have faith that I'll get something usable for this one. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form. LinkChildFields property (Access) 03/26/2019; 2 minutes to read +1; In this article. Note that this form/subform has three navigation bars: one below each of the two subforms and another one at the bottom of the window for the main form. The subform field type is very powerful and now that the capability is delivered to custom fields, you can collect groups of data and even repeating data (this plugin supports repeating subforms). Now add command button 'cmdGo' to frmMaster and paste the following in. Subform control. A subform is a collection of form elements that are stored as a single object. Subforms displayed on forms have full functionality. Adding subforms into this isn't an easy task. However, the simple filter cannot be used if the field you wish to filter on is not in the form. The record link id column generated for the MainForm report can be used to refer the related SubForm entries. Form inside the subform control: When the form inside the subform control is selected, a black square shows in the Select Form button at the upper left of the form. Referencing a control on an Access form is easy. when run the output show me the content of the "frmMainClient" and all the related jobs in the "frmJob" subform. A ccess lets you display data that is related to records in a form or report by using a subform or subreport. Add a button to the subform (i. Discuss forms that have multiple tabs with subforms bound to each tab 2. For example, you could place a hidden textbox on the main form referencing the textbox in subform #1. A Subform Cannot Link to Fields in a Subform of its Parent In a regular main to subform design, the Link Master Fields property would be based on a control on the main form. Referring to Controls on a Subform Sooner or later, you will need to refer to information in a control on another form - a subform, the parent form, or some other form altogether. Linking the sub-subform Given the restrictions of Access, I set up a senior and a junior subform, both linked in a master-child relationship to the Level 1 Trip form. What I need to do is calculate a field on the 2nd subform that is dependent on data on the 1st subform , In addition the Estimate_No, I need to also link by a field AREA. And third, the subform container control will let you swap out subforms as you desire. link 1 subform to another subform. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT. For this symmetric relation you can show the orders related to each item in the same way (main form of items, list box grid with orders). Choose the Linking Field. Instead of tabbing to the next subform (like its supposed to), it just sends the focus back to the first control in the first subform. If you are viewing the subform from the main form while in design view, must actually go into the container and select the subform to view its properties. Subform control. aspx -> SQLDB as I was able to do with an Access form - One to Many relationship [Answered] RSS 4 replies Last post Dec 13, 2007 02:44 PM by jpuckett. If you click. LinkChildFields property (Access) 03/26/2019; 2 minutes to read +1; In this article. 3) The grid control has a field of list boxes where the list boxes let you select multiple items into the subform's mapping table. Activate it and execute it. Access gives focus to. Before that you must needs to have complete knowledge on what this subform is actually. NP Access 2007, Tutorial 06, Review Assignment. The main form or report is based on a table with a primary key, and the subform or subreport is based on a table or query that contains a field with the same name and the same or a compatible data type as the primary key. Visual Basic for Applications (VBA) code and embedded macros that are attached to the form and its controls will still run, although some events are disabled in this context. The filter works great if I use it from the main form on a subform or from within the same subform, but if I use it from one subform to ANOTHER, it becomes invalid. I would like to change the way they are linked so instead of linking from Old ID, they link to New ID I don't know anything about code, is there a way to just change the cell it relies on?. A subform is a datasheet form that displays linked records in a table-like format. Changing subform "Source Object" property with VBA by Zm91cnN0cm9rZQ » Wed, 11 Aug 2004 17:35:01 GMT I want to open/activate a different subform based on the value of a combo box in the main form. For this symmetric relation you can show the orders related to each item in the same way (main form of items, list box grid with orders). Referencing a control on an Access form is easy. Although technically a control, subforms have some form characteristics as well. You now have a main or master form and a subform. Re: [access-l] Moving records from one sub form to another subform Brigit, It would be great to know what the purpose of moving people over from one subform to another and vica versa, but I did something similar you probably can use. tbl_AssetsOnLoan - frmAssetsOnLoantbl_Assets - frmA. If you want separate subform to be synchronized with another subform, you will need to set the Recordsource of the subform so its filtered by a value in the other subform. For instance, the subform included in the Customers form we just created displays linked customer orders. Link Child Fields Link Master. Name Case "frmOne" ' Do one thing. It must live within a subform CONTAINER control, which does several things. It was originally written in response to a question by Access World Forums member psych0tic1 in this thread: Another Visible/Hidden Form Field Question. Beginning Access Database Subforms What are MS Access subforms? The best way to think of a subform is a form within another form. Now right click on the top edge of the subform and from the pop up menu that appears select 'Properties' The properties to note here are. As far as Access is concerned, an embedded subform is just another control. So then you can filter the second subform's recordsource by the first subform link value Then requery the second subform on the first subform's current event. Linking the sub-subform Given the restrictions of Access, I set up a senior and a junior subform, both linked in a master-child relationship to the Level 1 Trip form. MS Access - Forms, Subforms, Tabs What do I use to accomplish my task? If this is your first visit, be sure to check out the FAQ by clicking the link above. SubFormHere. You may have to register before you can post: click the register link above to proceed. Activate it and execute it. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. Microsoft Access; Go to a record on one subform clicking on another subform. > Therefore, when I created a subform "Product History", I could not link it > directly to "Companies" form, in other words, Link Child Fields and Link > Master Fields is empty now. Access: How to get subform to expand. I want to click on a record on that subform and have it populate the form. A link to a tutorial or similar example would help. Their click event sorts the rows by the values in that column. 2) On another page of TabCtl0, create a subform control named 'sFrm2'. As far as Access is concerned, an embedded subform is just another control. MS Access: Items on drop down menu link to different subforms? Hi, I'd like to create a drop down menu with approx. Might take another look at. Subforms displayed as pop-ups are read-only; users cannot interact with them. The subform: PatientNameForm - includes all the personal individual about each family member, ie cell phone, insurance, etc. What are MS Access subforms? The best way to think of a subform is a form within another form. The syntax of your sql statement is wrong. I was wondering if anyone can refer me to a video say on YouTube that demonstrates how to link two subforms ? Or possibly an article that explains how to do this. When you change a field on a subform, every form that uses the subform updates. That form is embedded into the main form, and Access will automatically add the ID number from the main record to all of the records in the sub-table. This is a discussion on MS Access requery subform from another subform within the Microsoft Office support forums, part of the Tech Support Forum category.