Access Refer To Subform

allowMacro. When you use the Access 2002 or Access 2003 AutoFormWizard with the Orders, Products, or Categories tables, you automaticallycreate a main/subform. Last week the team was privileged to host our MVPs at a conference here in Redmond. Linking Subforms to an Unbound Control(s) on the Main (Parent) Form You want to link a Subform to the Parent Form but your Parent Form is UNBOUND. Workspace Participants can access a package's subforms by clicking the Go to Subforms link in the Form Name column on the Forms tab of the Manage Workspace page. will return another collection. The feature that makes the main/subform especially powerful is the way it links its two parts: the main form and the subform. Access 2010 set focus on subform control Just a quick post because I know I'll need this in the future. Access will then do all the heavy lifting. To explain one of my forms: Doing sales reports on different brands at different stores. Navision has limitations when we you want GUI components communicating each other. A row is a pre-defined variable available in on add row, on delete row and on user input action of a SubForm field. Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. I am going to try to explain to you how you can EASILY remember. I need to put the Total EstimatedAmount as a text box in Master Form below the subform. "Fields" are in tables, queries and recordsets. However, sometimes the wife may have kept her maiden name or the children may have a different last name due to divorce, so searching on the main form for the last name doesn't bring up their record. Count = 1 and you can refer to a control on that form using: Forms!MyForm!MyControl However, if that form contains a subform. Provided by Allen Browne, allenbrowne. Access will assume the Customer table fields should be placed in the new form because it is selected. 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. Note also that these two forms are continuous - which is not normal for an Access form. Access refer to subform control 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. For the experienced Microsoft Access user, navigating between main forms and subforms is an intuitive function. Loop Through Subform Instances A note today on a specific coding practice I have seen in a number of customer forms. From the "Lookup" subform, I want to click the hyperlink and navigate to the "Edit" subform. it should open the form with the selected details. To refer to other form properties replace. Since the subform inherits the permissions of the main form, you may not want to check the subform. That subform has some of the same properties as any other Access form object. run an UPDATE query. SetFocus is used when opening multiple copies of the same Access form. In this blog entry we will: Discuss forms that have multiple tabs with subforms bound to each tab; Discuss how this can slow your form load time due to resource constraints at startup. Subforms are considered part of the main form and lose their own identity once they are loaded. NOTE: Only subforms are discussed in the rest of this article, but all the information applies to both subforms and subreports. If you create a form from the "many" table, you won't get a subform. Using DoCmd. Showing or Hiding Microsoft Access Subforms: You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. To synchronize the information so that the subform automatically changes when the record in the main form changes, the LinkMaster Fields and Link Child Fields properties for the subform control are each set to CustomerID (see Figure 2). From the subform I need to able to retrieve the value of a text box on its parent form. If you need to. This MSAccess tutorial explains how to link a subform to a form in Access 2003 (with screenshots and step-by-step instructions). I want to refer to the date on the header to refer to the column of textbox controls. Subforms are useful tools in dealing with relational data in tables in Microsoft Access. referencing field in subform I want to reference the value of a field in a subform. Access will assume the Customer table fields should be placed in the new form because it is selected. php/Referring To Properties And Controls On Subforms. The record source of the main form is the c_List table. You can also move to a control on a subform by using the GoToControl action to move first to the subform and secondly to a control within subform. The links on this page direct to the best available sources found on the web, including Microsoft Office developer documentation, Allen Browne and The Access Web. record count), I found this always worked (whereas the former didn't for some reason). In this case, the main form can display the category ID, name, and description; the subform can display the available products in that category. For the experienced Microsoft Access user, navigating between main forms and subforms is an intuitive function. Accessing parent form from subform in Navision The Challenge. A subform is: a) A subordinate form within a form b) A smaller, independent form compared to another form c) A specialized form used to create a report d) none of these Chapter 5 Test Bank to accompany Accounting Information Systems, Cdn ed Simkin et al. However, there are some differing properties as well. When trying this with just the subform, it works fine. SQL The set-processing language in Access is SQL: Structured Query Language, which is an ANSI (American National Standards Institute) standard language. Steve is responsible for form rendering and the new templates in Access 2010. Access Subform Will Not Refresh Jul 19, 2006. I have a Main form with two subforms Sub1 and Sub2. To reference a subform: Access treats sub forms as controls on the parent form so to reference a sub form control you need the code Forms!FormName!SubFormName. The automatic default value is obtained by entering a reference to the filter field in the main form in the field: Default value. Referring to Controls on a Subform. My way around this is that I will use a subform so that Access knows exactly which record is being edited [a subform presents records of the second table one-by-one] OR I make a new form open when a user clicks an EDIT button. A subform is a collection of form elements that are stored as a single object. Right-click the existing form in the Navigation Pane, and then click Design View. MS Access 2003: Link a subform to a form. Subform is still a form. More than one subform can be used in a form design. In our little database we have here in the office I was wanting a specific control in a subform to become active when someone clicks in any of the blank space on the main form. All forms contain a root (parent) subform. Right now, I have this in (Subform A) txtFieldA's On Got Focus event. This form is named as HEADER FORM. This is often seen when viewing a form with a recordsource, and using a subform to show the related records in a subform. =Parent!OrderID Support and feedback. Split form allows you to have two views of your records at the same time - form view and datasheet view. You would click the link to open that same record in its own form. During our in-depth talks about Access 2010, some of these MVPs asked me about the new DoCmd and macro action called BrowseTo that we’ve introduced with Access 2010. I've just had to remind myself how to refer to a subform contained within a tab on a main form. By using the page subform as your repeatable subform for your data records, you'll find it much easier to. I have a main form which, via buttons, opens up a subform. (Q) How do I refer to a control found on a tab page when I'm using a tabbed form? (A) The tab control has no impact on the syntax for referring to a control. How to use Conditional Formatting for Subform or Datasheet Form. I have a main form with two subforms. You can even refer to controls that are on subforms on subforms (two levels down). Count = 1 and you can refer to a control on that form using: Forms!MyForm!MyControl However, if that form contains a subform. (Q) How do I refer to a control found on a tab page when I'm using a tabbed form? (A) The tab control has no impact on the syntax for referring to a control. Other users only have reader access to the section. Best Answer: You can reference the current record on the subform from the main form using [Me. Re: Refer to a listbox on subform BTW Best refer to the listbox and other objects on the forms as "controls" because that is what they are called in Access. GetProductID But I can't get it to work either? It would be a lot better if it was a Public Procedure Module or Function Module because you can call those form. There are command buttons in the form labeled 1 and 2 that let you swap between two versions of the subform. We need to be able to reference the subform control from the main Microsoft Access form. Right click on a selected subform. "Fields" are in tables, queries and recordsets. GoToControl. In a subform, there is a field that refers to a field or value in the main form. Also, for referring to any controls or methods on the subform you use. Bind SubForm with Text box to main form I am using access 2007--I have a query that I have designed that just brings up one value (with two fields: the ID. Subforms are considered part of the main form and lose their own identity once they are loaded. To explain one of my forms: Doing sales reports on different brands at different stores. Subforms are considered part of the main form and lose their own identity once they are loaded. To use paging with subforms, you need to understand how Access handles report pages. Processing Main/Subforms. The expressions. In this form is a subform called "Grades" that displays. Earlier versions of Access require you to createseparate main and subforms and then drag the child form from the Databasewindow to the design view of the parent form in order to create a main/subform. The Simple Approach to Creating Microsoft Access Subforms Once you've established the table relationship, Access makes it easy to create a subform. You can also move to a control on a subform by using the GoToControl action to move first to the subform and secondly to a control within subform. A subform is: a) A subordinate form within a form b) A smaller, independent form compared to another form c) A specialized form used to create a report d) none of these Chapter 5 Test Bank to accompany Accounting Information Systems, Cdn ed Simkin et al. More specifically, the table must be the "one" part of a one-to-many relationship. The Filter property of forms (introduced in Access 95) makes it easy to filter a form based on a control in the form. The following example uses the Parent property to refer to the OrderID field, which is present on the main form and report. If the only way that you have created a subform on a main form is by using the Form Wizard, the Subform Control Wizard, or by dragging and dropping a form object from the Database window to the main form, then you may not have ever had the need to populate these properties. Please provide a FormCalc sample if possible. i want to select a record from subform and want to click on a button called edit. Forms: Refer to Form and Subform properties and controls. [Form]![control name on subform] where [subform control name] is the subform control and NOT the subform. So if you open a form MyForm then Forms. Forms: Refer to Form and Subform properties and controls. If the parent form is a read-only form, the parent form's status will change to Passed when all of the subforms are in the Passed status. Access Subform Will Not Refresh Jul 19, 2006. How To Add A Subform To A Form In Access 2016 In Access you can add a subform to a form to provide related data from a one-to-many relationship. Subform2 is the name of the subform CONTROL on the 1st subform. In that article, we mentioned when setting the master link field of a subform, you should always reference the control rather than the field name. For example if. this is in the ballpark in the checkbox's after update event docmd. LinkMasterFields and LinkChildFields are listed on the Data tab of the Property Sheet when the subform control is selected. Access vba refer to subform control 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. The task is to write a loop that examines each subform instance in a repeating subform definition. Basically a Russian doll scenario with buttons. How do I reference a control on a subform within a subform. I set the selected subform via the sourceObject property. You can place the subform itself on a power form; this action is referred to as embedding. The Filter property of forms (introduced in Access 95) makes it easy to filter a form based on a control in the form. (Or in Access 2007 select Create/More Forms/Form. The various sections presented in this document will help you to build a solid knowledge foundation of the software. Workspace Participants can access a package’s subforms by clicking the Go to Subforms link in the Form Name column on the Forms tab of the Manage Workspace page. Subforms save redesign time. In this example, I will use the table customer for subform data. Basic and Access. LinkMasterFields and LinkChildFields are listed on the Data tab of the Property Sheet when the subform control is selected. I want to refer to the date on the header to refer to the column of textbox controls. Most of time, a field formatting is not working with the Datasheet form. If you create a form from the "many" table, you won't get a subform. A customer requirement might be: When user updates Quantity field on subform to a non-zero value, system updates text color of the status field on parent form to red. From the subform I need to able to retrieve the value of a text box on its parent form. How do I reference it in VBA? MS Access - get value of a control on the parent form from subform. Refreshing a subform based on combo box selection When I started working on this database it was in Access 2007. What is the syntax used in subform's VB code to refer to a control on its "parent" form? I've had it, but I sure. Showing or Hiding Microsoft Access Subforms: You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. In my MS Access application, I am using a form which contains only two controls - a textbox and a command button. To refer to a subform or a control on a subform, you must remember that Access treats the subform as a control. Hi, What do you think to the idea of having a separate back end to only store attachments? Thanks. For example, the following code uses the Form property to access the OrderID control on a subform contained in the OrderDetails subform control. One the first page you might have found Selected Rows in a Table Control. In this blog entry we will: Discuss forms that have multiple tabs with subforms bound to each tab; Discuss how this can slow your form load time due to resource constraints at startup. Dim tbDays(1 To 14) As Control ' Textbox Array for the Days of the week. This is an easy way to access form objects, even if there are multiple forms on a web page, because the form's name or id attribute are never directly used. Controls user access to the contents of a container object, such as a subform. In my MS Access application, I am using a form which contains only two controls - a textbox and a command button. The subform will be *inside* a subform contorl. Queries and tables can also be used, and even forms in Form View. Got an Access database with a simple one to many relationship between Header and Transaction tables, We then need to display the sum of all values from a field (tValue) in the Transaction table. Referencing a control on an Access form is easy. The page below shows both references that start from the Main form and also references starting from the subform. Please help!! For example, if: frmMain = main form NavigationSubform = navigation subform container frmEmployees = form contained within NavigationSubform. Access allows you to open a subform in a new window, which you can resize to get more working space. what you mean by "subform", as there is no "Subform" object in Access --there is a Subform Control, into which a Form may be embedded. Microsoft Access Tips for Serious Users. I have an Access 2010 database with a navigation subform, but I'm never quite sure how to reference objects in other forms contained with the Navigation Subform. Form!OrderID. How can a subform inside a panel of parentform access parent form controls on button click Tag: c# , forms , panels I have a parent form which has a textbox1 and a panel1 and a button1. Objects haveproperties and methods within Access. Access Subform Will Not Refresh Jul 19, 2006. Please provide a FormCalc sample if possible. The subform control will be on the main form and it may or may not have the same name as the subform inside it. > How do I reference a text box in S2 from VB code?. Subforms, subforms, subforms It is a word that generates fear into the sturdiest Access developer. When referring to subforms, you want to refer to the subform CONTROL name, control on the parent form which houses/displays the subform, and NOT the name of the subform itself UNLESS they have the EXACT same name. Both A and B are in datasheet view. How to refer to controls in a subform in a Microsoft Access database. The subform does not know how many pages there are in the report because the Parent form doesn't know. Sub-Sub forms. Apart from showing the required syntax for (a) referring to controls of one group of nested subforms from another group of nested subforms and (b) referring to subroutines (contained in form's modules) across various levels of nested subforms, the sample db demonstrates the syntax for referring controls on forms / nested subforms in SQL statements. It is the data column name of the Subform element on the Parent form. However, this specification does not override the access control list for the database. With this feature you can present many related records in just one record. Since the subform inherits the permissions of the main form, you may not want to check the subform. The task is to write a loop that examines each subform instance in a repeating subform definition. netbumbler, Your subform is a query datasheet which is just a form. An overview of the remaining parts of SQL, for instance how to update the database through SQL. Let's assume frmOrders is the parent form and frmOrderItems_sub is the name of the subform inserted into frmOrders. Hide a subform in MS access There are different ways of hiding or displaying a sub form in Microsoft Office Access. (Or in Access 2007 select Create/More Forms/Form. 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. If you want to display data in a subform based on a value on the parent form then perhaps you could use the LinkChildField/Master Fields properties. patil (0 replies) printing images in acces report by jbarrios (0 replies) Highlighting Text field for input by sad1121 (0 replies) how to save record to another table in the same ms access database. [0]: This is the position in the array. Conditions must be met for Access to automatically link the child and parent: The underlying tables have relationships defined. Controls user access to the contents of a container object, such as a subform. That is simply not the case. [GUIDE] Refer to Microsoft Access Form, Subform properties and controls Dave Posted on 05-Nov-2013 Posted in Access 2010 — No Comments ↓ For these examples:. thanks in advance. but when tried with the subform in the mainform, the query asks me to enter a parameter value. 2) On another page of TabCtl0, create a subform control named 'sFrm2'. In order to reference a subform, you need to use the Form property to associate the form variable with the subform. Yes you did mate, I did reply to the post that I still didnt get it. I think that you want to find the row (s) that are selected in a 'Table Control' that is located in a sub form. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Access 2K3/XP: Referring to a sub-subform from a subform? This is similar to how you must use a ! between the main form and the subform to refer to it. Let’s assume frmOrders is the parent form and frmOrderItems_sub is the name of the subform inserted into frmOrders. When you use the Access 2002 or Access 2003 AutoFormWizard with the Orders, Products, or Categories tables, you automaticallycreate a main/subform. Forms behave differently when they are used as subforms, and this can be a challenge when using VBA. All works fine if the user has administrator permissions. Individual subforms enclose a combination of objects that produce fillable regions (fields) and non-fillable regions (draws). When you change a field on a subform, every form that uses the subform updates. Subforms can contain the same elements as regular forms. From the "Lookup" subform, I want to click the hyperlink and navigate to the "Edit" subform. This article applies only to a Microsoft Access database (. I need to set the caption for a label from an event in a subform. In this article we are going to show you how to display totals taken from your subform, and display these in controls in your main form. How To Add A Subform To A Form In Access 2016 In Access you can add a subform to a form to provide related data from a one-to-many relationship. Visual Basic reference. Microsoft Access Tips and Tricks How to Get a Reference to a Subform's Parent Control When you are writing code for a subform, it's easy to get a reference to the parent form that holds the subform. In this form is a subform called "Grades" that displays. ) It's also why, in many versions of NAV Classic, the Sales Line FactBox (Item Information) is just a set of fields on the Subform itself, which already does get updated after the user selects an Item No. And inside S1 I've got subform S2. In this article we are going to show you how to display totals taken from your subform, and display these in controls in your main form. How to Create Subform. The task is to write a loop that examines each subform instance in a repeating subform definition. Best Answer: You can reference the current record on the subform from the main form using [Me. Most of time, a field formatting is not working with the Datasheet form. As long as the subform is available in the form Heirarchy, the minimum count will be 1. Conditions must be met for Access to automatically link the child and parent: The underlying tables have relationships defined. To refer to a control on the subform, you should use syntax similar to: Forms!frm_Main. I need to set the caption for a label from an event in a subform. Access also tries to link the subform to the main form, based on the relationships that have been defined in your database. We can create a query with one 'sum(tValue)' field but can't see anyway to get that displayed in a form. Thanks in advance for any assistance. MS Access 2003: Refresh the contents of a subform whenever the record in the main form changes This MSAccess tutorial explains how to refresh the contents of a subform whenever the record in the parent form changes in Access 2003 (with screenshots and step-by-step instructions). If I enter data into the subform, it doesn't recognise the association with the parent ID. If the parent form is a read-only form, the parent form's status will change to Passed when all of the subforms are in the Passed status. What is the syntax used in subform's VB code to refer to a control on its "parent" form? I've had it, but I sure. Subforms can contain the same elements as regular forms. The result of export is that data from both parent (datasheet or forms) and child (subdatasheet or subform) get exported to MS Excel while keeping the drill-down view. You will need to add the Visual Basic code. So when I go back into the form, the data I have just entered in the subform has disappeared. Provided by Allen Browne, allenbrowne. Recently, we published an article describing how to Synchronize Two Related Subforms on a Microsoft Access Form. I have a command button on another form which has a macro on the onclick event to open the form EditOffence and show the subform. ) It's also why, in many versions of NAV Classic, the Sales Line FactBox (Item Information) is just a set of fields on the Subform itself, which already does get updated after the user selects an Item No. The Microsoft Access Booklet Series will provide you the necessary knowledge on how to use Microsoft Office Access 2016. You can enter this expression in a bound control on the subform. Note that you may employ the GoTo Control method to move to a subform, which is a type of control. " Let's say frmA contains subform fsubB, which contains subform fsubC, which has control txtC. You can also reference an existing subform on a power form with an alias; this action is referred to as reusing. The subform does not know how many pages there are in the report because the Parent form doesn't know. Specify a binding method for controlling how the subform's objects are mapped to data. what you mean by "subform", as there is no "Subform" object in Access --there is a Subform Control, into which a Form may be embedded. Split form allows you to have two views of your records at the same time - form view and datasheet view. How to Add a Subform to a Form in Access 2016 You can add a subform to a form to provide related data from a one-to-many relationship. Subforms can contain the same elements as regular forms. Subform2 is the name of the subform CONTROL on the 1st subform. If you continue to use this site we will assume that you are happy with it. A row is a pre-defined variable available in on add row, on delete row and on user input action of a SubForm field. Forms: Refer to Form and Subform properties and controls. MS Access Questions and Answers › Category: Access Form › how to link a subform and a navigation form within a mainform 0 Vote Up Vote Down Anonymous asked 4 years ago. Individual subforms enclose a combination of objects that produce fillable regions (fields) and non-fillable regions (draws). I need to put the Total EstimatedAmount as a text box in Master Form below the subform. Any help is always greatly appreciated. Form!OrderID. To open the physician form within the navigation form as a subform,follow the below steps and give the physician form properties in the subform while creating. In this article we are going to show you how to display totals taken from your subform, and display these in controls in your main form. txtFieldA has the focus), I want Subform's B filter to change. Earlier versions of Access require you to createseparate main and subforms and then drag the child form from the Databasewindow to the design view of the parent form in order to create a main/subform. In this blog entry we will: Discuss forms that have multiple tabs with subforms bound to each tab; Discuss how this can slow your form load time due to resource constraints at startup. To synchronize the information so that the subform automatically changes when the record in the main form changes, the LinkMaster Fields and Link Child Fields properties for the subform control are each set to CustomerID (see Figure 2). Use a Form/Subform, with a combo box on the main form, and the data in the subform, bound by the LinkMasterFields and LinkChildFields properties of the subform control. You can place the subform itself on a power form; this action is referred to as embedding. Accessing parent form from subform in Navision The Challenge. Displaying Subform Totals in a Main Form in Microsoft Access. record count), I found this always worked (whereas the former didn't for some reason). ) It's also why, in many versions of NAV Classic, the Sales Line FactBox (Item Information) is just a set of fields on the Subform itself, which already does get updated after the user selects an Item No. Referring to Controls on a Subform. The subforms are linked to the main form my two fields. But, if you are wanting a property or method on the subform itself, you must tell Access that you want the form, not the subform control. "Fields" are in tables, queries and recordsets. 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. 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. form to the onClick event handler of a form button, this function would get the reference to the form object. Navision has limitations when we you want GUI components communicating each other. I have a form in the database that displays records from a view, with a subform displaying linked records from a different view. Form!SubFormControlName. To refer to other form properties replace. Description. In Microsoft Access, when a main form and subform are created based on one-to-many relationships, you can display aggregate information in the main form; for example, a total COUNT of customer records for each sales person or a SUM total of sales amounts that have been displayed in a subform. The task is to write a loop that examines each subform instance in a repeating subform definition. Microsoft Access lets you quickly create forms displaying one-to-many relationships with subforms. Using subforms. is it possible to create exe file for access file by edwards142paul (13 replies) Showing One Record of a Subform by smita. Access 2010 set focus on subform control Just a quick post because I know I’ll need this in the future. Dim intOrderID As Integer intOrderID = Forms!Orders!OrderDetails. [Form]![control name on subform] where [subform control name] is the subform control and NOT the subform. Then, the procedure uses the control's Form property to return the subform's recordset, which, in turn, allows me to access the RecordCount property value. Normally, when you load a form, Access adds it to the Forms collection. To create another record from the standard list view, click the Subform element and a new record will open. When to use a form's recordset and when to use recordsetclone Recordsets are an essential tool of any Access programmer, there are many types and are used in a wide range of situations, today we’re going to talk about form recordsets and provide some examples of their use. Modifying a subform in Design view. What is the syntax used in subform's VB code to refer to a control on its "parent" form? I've had it, but I sure. Use a Form/Subform, with a combo box on the main form, and the data in the subform, bound by the LinkMasterFields and LinkChildFields properties of the subform control. If you do not see the subform in the Heirarchy then the count will be 0. To move the focus to a control on a subform, first move the focus to the subform control and then a second SetFocus for the control on the subform. Dear Best STL, I've created a subform which will contain from one to four records. Subforms in Access provide a powerful way to easily see one-to-many relationships without writing code, using the LinkMasterFields and LinkChildFields properties. You will need to add the Visual Basic code. If you continue to use this site we will assume that you are happy with it. The Order Totals at the bottom of the 'Sizes' subform. Description. Sometimes, we may have upwards of 5 or 6 subforms per form. Subform2 is the name of the subform CONTROL on the 1st subform. Subforms are most commonly forms displayed as datasheets or continuous forms that show multiple records. allowMacro. Provided by Allen Browne, allenbrowne. To express that arrangement in terms Access can decipher, you need the Form property as follows. Referring to Controls on a Subform. This allows you to present many related records within a record. If you want to display data in a subform based on a value on the parent form then perhaps you could use the LinkChildField/Master Fields properties. the client id of the command component inside the subform whose action should be invoked by default, when the enter key is pressed with focus inside the subform. I have a subform with a table of filenames. Make Purchase Order, Part 1 Create the Make Purchase Order Code Creating a PO with a Recordset Get the assigned Autonumber for a record Check if there is a PO for this vendor 5. I think that you want to find the row (s) that are selected in a 'Table Control' that is located in a sub form. It's kind of a hack, but you could place some type of update statement. As long as the subform is available in the form Heirarchy, the minimum count will be 1. In a subform, there is a field that refers to a field or value in the main form. SubForm: ProjectDetail. Manage Subforms. Access 2007: Refering To A Control On A Subform Within A Form On A Tab Wow! typing that heading is more complicated that solving the problem! I have a main for that contains a number of tabs (let's call the form "frm_MainForm"). (In general, it's rather difficult in Classic, but not impossible, to update form related information on Subform changes.