Ms Access Subform Get Value From Parent Form

MajP's DLookup() is missing a closing ")". hi how do i reference a field on the parent form from the child form e. Rather that create a module (I guess I could if I really had to), I browsed and found I could call the procedure that the parent uses, from the. Using JavaScript to access form objects when there are multiple forms ; How to set the value of a form element using Javascript ; HTML Form Tutorial Part III : Still More Input Elements ; How to get the value of a form element using JavaScript ; How to get the value of a form element : Drop downs and lists. If you need to. Controls on a nested Sub-Sub form. txtFieldA That is, whatever value the cursor sits on in Subform A Field A, make SubformB's filter change so only Subform B Field A values are shown. If you name a subform control the same as the subform itself, you will indeed get issues. The Sample application Subform Details in Email comprises of a Student Form which is a parent form with SubForm. I have to have the textboxes in a subform it doesn't work. You can add a subform to a form to provide related data from a one-to-many relationship. The subform or subreport is called the child. In our example we have a main form which shows the customers and the subform which shows all the orders for the customer: Independently the forms function by themselves, however it is more meaningful if they are combined. Microsoft Access Tips for Serious Users. By continuing to browse this site, you agree to this use. openEntityForm. It created one of the world's largest private bus systems, the "Connector", to transport people from outside the company; for on-campus transportation, the "Shuttle Connect" uses a large fleet of hybrid cars to save fuel. If the user needs to add a new Employee, he clicks a button which opens the Employee entry form. Using acDialog causes the form's Modal and PopUp properties to be set to Yes. Creating forms in Access 2007 A form is a database object that you can use to enter, edit, or display data from a table or a query. In order to reference a subform, you need to use the Form property to associate the form variable with the subform. Have questions or feedback about Office VBA or this. Refer to Parent form. I have a Sub form on my Main form, I want to update subform control txtCalls from Main form txtCallsCount. Subject Catalog. I have to show or hide a grid column value based on another grid column on form load. How to build a dynamic query with values from a search form in Access 2007, in Access 2003, or in Access 2002 Contenu fourni par Microsoft Advanced: Requires expert coding, interoperability, and multiuser skills. There's a. Will change of value of link field on Parent form change automatically value of. I would like to requery the total given in the text box (based on a query) on the AfterUpdate event of a subform. Date Picker without ActiveX control. Therefore, the width of a report should equal or narrower than a piece of paper (11" x 8. Update All Open Forms. In your MS Access application, if you are using Microsoft Web browser, we may have to interact with the Javascript variable inside the loaded page. And if I select a different client from the combo box, have the orders in the subform change to reflect the newly selected clients orders. You can use forms to control access to data, such as which fields or rows of data are displayed. Requery End Sub. The form contains a subform displaying a number of related records summarized in datasheet view. This is a good question. There is no obvious method exists in the Web browser control but using the following trick you can get/set the Javascript variable in the webpage. hi guys can you help me to convert this to case select statement, this is my first time using case select statement. Either way, whether filtering or searching, SubForms are designed to present the results through various Form Controls (Table grids, Text Boxes, Images, etc. If you have two existing Access forms and one can serve as the subform for another, open the form you want to be the main form. Opening Comments about Forms A form is a database object that you can use to enter, edit, or display data from a table or a query. The most up-to-date version of Microsoft Access is always available with an Office 365 subscription. Download the search database (23KB zipped). How to reference parent form from subform when parent name can be different. This is because, unless you specify otherwise, a combo box. How to pass a value from any area of your Microsoft Access program to any other area, even to a query used to filter the data in an Access report or form. Filter Subform based on Combobox value in Main form Hi I have a form (Field Selection Form) with ComboBox (Combo0) and a sub form (SelectField SubForm) which call table (technical structure) which has three columns, Table, Fields and Selection (Yes/No). There was a question on the Forum asking how to update a Web Browser Control with values from a SubForm. In the two subforms scenario, the second subform is filtered on a value in the first subform. You will find that as you start to add value to any of the other fields in the subform, that Table2_ID will generate automatically as it is an autonumber and the value in Table1_ID in the subform will reflect the value of Table1_ID in the main form. You might use this in a generic routine that does something with forms. MajP's DLookup() is missing a closing ")". Main Form and Subform Concepts. 5 The AutoForm Wizard accom-modates the relationship between the Catalogs and Plants tables. MS Access automatically pairs the fields between the master (Parent) and child to filter the data in the subform. For instance, the subform included in the Customers form we just created displays linked customer orders. Microsoft Access / VBA Forums on Bytes. Therefore, you probably will need to create a form within Access 2013. I don't think this is too difficult, I just don't know how to pass ID's or values to subforms, or how to pass values between forms. It illustrates how to use: Exact matches, Partial matches (wildcards), A range of values, Delimiters for. For these examples Subform1 is the name of a subform control on frmMain, Subform2 is the name of another subform control placed on Subform1. Get a Value from an Open Form Field Using Forms!FormName!Field Notation To Read a Form Value. Address books. Update All Open Forms. Search criteria. Here, you will have the option to chat with a tech support associate, if you are getting in touch with us regarding a particular concern or relevant to a requirement you’ve. Run SQL Statement based on the control for this column, Process other data, etc Next I. You can use forms to control access to data, such as which fields or rows of data are displayed. We need to be able to reference the subform control from the main Microsoft Access form. - wbeard52 Sep 27 '13 at 22:16. Because the subform is now based on a union query, the recordset is not updateable, and I have lost the bto use a checkbox on that row. Our application has numerous subforms. How to reference an Access subform By Susan Harkins in Microsoft Office , in Microsoft on July 27, 2008, 5:00 PM PST Referencing a control on an Access form is easy. The Default View property for the Form (in this case your subform) shows a value of "Datasheet". This lets you combine several reports into a. A Subform Cannot Link to Fields in a Subform of its Parent. Microsoft Access Tips for Casual Users. Strangely, the subform displayed as a form in Form Design View but it actually shows as a datasheet when in Form View. If you need to. Here’s how. In order to reference a subform, you need to use the Form property to associate the form variable with the subform. Address books. How do you reference a control on a parent form from a subform? My subform is not tied with a unique identifier. Form Events. Name Case "frmOne" ' Do one thing. Sometimes you need more control which you can achieve by making custom buttons with DoCmd. Have questions or feedback about Office VBA or this. Either way, it displays the same result for the user. So technically, it could be argued whether this is actually a subform, or just a subdatasheet. In the two subforms scenario, the second subform is filtered on a value in the first subform. Imagine a scenario where you are looking at a record displayed on a form. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Access 2019 is compatible with Windows 10. Now in Access 2010, it's not requerying the subform based on the combo box selection. For instance, the subform included in the Customers form we just created displays linked customer orders. I have a form / subform where the main form holds Company details, and the subform holds Contact details. subform should know nothing about main form and it should be up to main form to manage itself. This tip ‘Form Events’ is suitable for all versions of Microsoft Access. Give your workflows a powerful kick start. com Refer to Form and Subform properties and controls I'm glad this worked out. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form. in the Parent which immediately picks up that value for display: subform while txt103 is on the. One record per form. I would like to requery the total given in the text box (based on a query) on the AfterUpdate event of a subform. About subforms. Filter parent form from subform. How do you reference subforms in this situation? Thanks in advance for your help! Gary. Since the subform inherits the permissions of the main form, you may not want to check the subform. Do I need to turn on any object library references?. Use an Existing Form as a Subform. I have to have the textboxes in a subform it doesn't work. Later on, parents may face a possible state probe for child abuse. Installation Guide for Symantec Endpoint Protection and Symantec Network Access Control. By way of finishing the reference as promised in my first post :) So I have a calculated control that requires the value from the subform of the parent form within the navigation control. A subform is a form that is nested inside of another form. The Invoice form at the top of this page is a rough draft of what we really need. Create subform default values based on value set in main form If you are refering the subform field from the parent form: default value--Access picks up that. I have a second subform that uses the same query and can get it to update fine, but the text box will requery the entire 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. Download the search database (23KB zipped). The following is a condensed version of part of one of the VBA Lessons it should give you an idea of what events are and what they can be used for. Adding that many can be a real drag on performance if you’re not careful. Calendar without ActiveX. Relational data refers to the one-to-many relationship between records that are stored in separate tables. MS Access 2007 Starting with MS Access 2007, the date/calendar functionality is built in and there is no longer a need for a separate ActiveX component. The name of form controls need not be the same as the name of the forms. Searching for support on Main form, Subform? We make it easier to deal with, solve, meet the criteria you may have regarding Main form, Subform. In order to reference a subform, you need to use the Form property to associate the form variable with the subform. Refer to Parent form. Humanities & Social Sciences. Best Answer: You can reference the current record on the subform from the main form using [Me. Learn more about how we can help at JotForm. Passing Data from One Form to Another Form: MS Access Nana Sara (Advanced Programming In Access 2013) Linking Parent Form Controls to Calling a Value from a Subform to a Main Form. txtFieldA That is, whatever value the cursor sits on in Subform A Field A, make SubformB's filter change so only Subform B Field A values are shown. Learn more. In general it's not a good idea to access another form's control variables directly. I have tried everything possible but it seems that the form_current is the only way to access the variable any suggestions to why I get a 0 value for a variable passed from the main form to the subform. In this article I am going to walk through the process of building custom forms using SharePoint Designer 2013. Because the subform control on the form is actually being filtered, we set the report's filter equal to the subform's filter. There's a. I have a parent form and a subform that I want to create a save button on the parent form that will save both the main form and subform when pressed. Rather that create a module (I guess I could if I really had to), I browsed and found I could call the procedure that the parent uses, from the. FilterName refers to a query in the current database. I could unable to populate option set field (pick list field) value from on form to another form. I tend to get confused, so I will explicitly define the path when I'm using a subform. Navigation Control - Subforms - Microsoft Access / VBA. I'd like to be able to select multiple rows in the datasheet subform and then change a value on each Get Selected Rows from Datasheet Subform - Microsoft: Access Forms - Tek-Tips. Open a Form from another Form (disabling the parent form until the child form is closed) in Access 2007 | 2003 Set the value of a textbox based on the value of another textbox in Access 2003 Set up a text box to display the difference between two dates in Access 2007 | 2003. We are going to create three separate forms for a custom list. * * Please note that integers in PHP are limited to 32 bits, unless they are on * 64 bit architecture, then they have 64 bit size. Provided by Allen Browne, allenbrowne. How do you reference a control on a parent form from a subform? My subform is not tied with a unique identifier. Get a Value from an Open Form Field Using Forms!FormName!Field Notation To Read a Form Value. In the two subforms scenario, the second subform is filtered on a value in the first subform. On a subform I created a combobox which I want to populate with ClassIDs that match the main forms Individual. An efficient search form creates the criteria from only those boxes where the user enters a value. Approach 1. You might even be able to turn on the wizard, add the subform and be guided through the process. NoLoan Field value as i wanna clicked. MyLab Math for Quantitative Reasoning -- Student Access Kit. Item [Forms]![Name of the form your going to open goes in here]![The field name that the data will go into goes here] Expression [Forms]![Name of the form your taking data from goes here]![The field name where the data is comming from goes here] You also have to have an initiator to start the transfer ON THE ORIGINATING form. Item [Forms]![Name of the form your going to open goes in here]![The field name that the data will go into goes here] Expression [Forms]![Name of the form your taking data from goes here]![The field name where the data is comming from goes here] You also have to have an initiator to start the transfer ON THE ORIGINATING form. Displaying Subform Totals in a Main Form in Microsoft Access. Add the subform at the bottom of the "Orders2" form. A field formatting by using VBA code will work most likely for a single form. This is my scenario: Form A (Single form) and Form B (Datasheet view). This property refers to a form object. Create forms in minutes Send forms to anyone See results in real time. Your code's doing the reverse of what you say you need to do. When you create a subform from a table (like in the above example), you won't get the extra form. Your code assigns the text from the other form's textbox to your current form's textbox (but you are trying to do the opposite if I understand it right). I would like to requery the total given in the text box (based on a query) on the AfterUpdate event of a subform. Filter Subform based on Combobox value in Main form Hi I have a form (Field Selection Form) with ComboBox (Combo0) and a sub form (SelectField SubForm) which call table (technical structure) which has three columns, Table, Fields and Selection (Yes/No). The related subform The main form This form is special because it includes data from both the Catalogs and the Plants tables, even though you didn’t tell the wizard to do so. New Relic Synthetics scripted monitors: Description of every function available for Synthetics scripted monitors version 0. Requery all open forms and return to last record. In this video I further explain why the calculation in the main form has to be written to call a value from the related form (subform). A subform is "embedded" within a subform control that lives on the main form. How to reference parent form from subform when parent name can be different. Filter parent form from subform. In that main/parent form i create text box, called Text7, and put T_Loan1 in subform object at footer. CHAPTER 8 CREATING AND USING DATA ENTRY FORMS 131 FIGURE 8. The primary form is called the main form, and the form that is enclosed in form is called the subform. Additionally, subforms support the form-level properties: Update on Businessview and Fetch on Businessview. You can use forms to control access to data, such as which fields or rows of data are displayed. Specify whether you want to open the form in Form view, so that you can view or enter information, or in Design view, so that you can modify its design, and then click Finish. 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. Web resources about - Main Form Text Box Referencing a Subform Field - comp. How do you reference subforms in this situation? Thanks in advance for your help! Gary. You can get string representation for formatting. Access Archon #173 Introduction. Solid Block Font for use on continuous forms in Access 97. When a user selects a Material value on the parent form, I want the sub-form to only display those records that have that same Material value. When a textbox value changes on subform (A) I would like to set the value of a textbox on subform (B) equal to the changed textbox on subform (A). If you need to. The SQL statement that the Query Builder generated is now written into the Row Source property of the combo box. This is because the subform/subreport control is displaying data directly from the table. MS Access automatically pairs the fields between the master (Parent) and child to filter the data in the subform. The default value acWindowNormal shows the form as normally done in Access. Form with subform on tab page; Report with subreport in Detail. Requery End Sub. The DoCmd GoToControl method moves the cursor (sets focus to) a field or control on a form in VBA. On the parent's form, create an On Load event that make the control visible in case varIsVisible = True (using straight-forward SetProperty). You might even be able to turn on the wizard, add the subform and be guided through the process. To format a field/column in the datasheet form, we will use a Conditional Formatting tool. This is part one of two posts on the topic. Humanities & Social Sciences. Create Forms in Access 2007 Training Session Handout Page 3 Topics came directly from Microsoft Access Help. - wbeard52 Sep 27 '13 at 22:16. Add a TextBox Control and a Label. For instance, the subform included in the Customers form we just created displays linked customer orders. A subform is a form that is nested inside of another form. If the user needs to add a new Employee, he clicks a button which opens the Employee entry form. Using acDialog causes the form's Modal and PopUp properties to be set to Yes. Parent!ControlName--Dirk Goldgar, MS Access MVP. Forms in Access are like display cases in stores that make it easier to view or get the items that you want. referencing field in subform I want to reference the value of a field in a subform. I tend to get confused, so I will explicitly define the path when I'm using a subform. I have to have the textboxes in a subform it doesn't work. Later on, parents may face a possible state probe for child abuse. When a textbox value changes on subform (A) I would like to set the value of a textbox on subform (B) equal to the changed textbox on subform (A). An information value dispersing candy for rehab people affiliated with these holiday cottages. Edit the default display form of the parent list again, add a content editor web part and link it to the following script which I'll be placing in my Site Assets library. But,I said you canremember how to do this because there is an easier pattern to remember. An efficient search form creates the criteria from only those boxes where the user enters a value. It is placed within a tab control in the parent form. ms-access Wikipedia:Referencing for beginners - Wikipedia, the free encyclopedia References (refs) on Wikipedia are important to validate writing and inform the reader. I currently have a form that contains a subform, which has 4 subforms in it. Searching for support on Main form, Subform? We make it easier to deal with, solve, meet the criteria you may have regarding Main form, Subform. About subforms. Microsoft makes use of alternative forms of transit. If you need to. I've set the primary Key as the Patient ID but when I add in the Command buttons they are not populating the Patient Id. Setting the Link Master and Link Child properties will default the values in the subform to the values in the main form. Installation Guide for Symantec Endpoint Protection and Symantec Network Access Control. A subform is "embedded" within a subform control that lives on the main form. How to use Conditional Formatting for Subform or Datasheet Form. In other words, what if you had a form with a subform with a subform with a subform with a subform. The following is a condensed version of part of one of the VBA Lessons it should give you an idea of what events are and what they can be used for. Navigation Control - Subforms - Microsoft Access / VBA. Microsoft makes use of alternative forms of transit. I am in the Form_Current() and when I click on a different record, I want to capture the current value of the field (EmaiGUID) to use to pass to a function. Forms![ActivityLog_subform]![txtCalls] = Me. passing information from subform to main form? - Microsoft Access. Previous versions include Access 2016, Access 2013, Access 2010, Access 2007, and Access 2003. Subform links to Main Form: MS Access Form in Access. This script will read the ID of the parent from the Query String variable "IssueID" and then set the value of the Lookup field on the form to that value. Add a TextBox Control and a Label. But there's a catch. If the user needs to add a new Employee, he clicks a button which opens the Employee entry form. Diana has 9 jobs listed on their profile. We can create a query with one 'sum(tValue)' field but can't see anyway to get that displayed in a form. Place a text box on the form Format it to display dates Enable the display of the Date picker. Access names the forms based on the titles that you type, and labels the subform based on the title that you type for the subform. Dear Best STL, I've created a subform which will contain from one to four records. The DoCmd GoToControl method moves the cursor (sets focus to) a field or control on a form in VBA. How to pass a value from any area of your Microsoft Access program to any other area, even to a query used to filter the data in an Access report or form. Most of time, a field formatting is not working with the Datasheet form. In your MS Access application, if you are using Microsoft Web browser, we may have to interact with the Javascript variable inside the loaded page. 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. The form contains a subform displaying a number of related records summarized in datasheet view. Hi, I have a parent form with a subform in datasheet view. If you switch the form into Form View and open the combo box list you will see that only the Primary Key field is displayed (Fig. MyLab Math for Quantitative Reasoning -- Student Access Kit. Notice we are requerying theTotal sub form at the top of the form. Lookup values are stored in Sharepoint lists instead of lookup fields. Referring to Controls on a Subform. 0, set the form's DefaultEditing property to Data. - wbeard52 Sep 27 '13 at 22:16. CurrentRecord where sbfControlName is the name of the subform object on the main form, *not* the name of the form you created as the source object for that subform. This is part one of two posts on the topic. Filter = "[lngFieldA] = " & Me. Access 2007 VBA Update Parent Form With Subform Combo Box Value I have an Access 2007 form [frmTrngRqmts] with a subform [subfrmTrngCourses]. With acDialog your calling code should not continue until the form is closed. Rather that create a module (I guess I could if I really had to), I browsed and found I could call the procedure that the parent uses, from the. Our application has numerous subforms. Finally, to enhance reuse, you can associate any number of functions with a subform at design time. [Solved] Get Value of Selected Item in Subform. The sub form is like a valid value table and I want to update a table that need the parent forms. and Form3 should displays the summation of two integer values. 11 Access asks for confirmation. I have to have the textboxes in a subform it doesn't work. How to Get a Reference to a Subform's Parent Control. OpenForm using FilterName. oDoc=thiscomponent. Setting the Scene. In this video I further explain why the calculation in the main form has to be written to call a value from the related form (subform). Displaying Subform Totals in a Main Form in Microsoft Access. Update All Open Forms. Q: How can I run a report showing just orders from a specific customer - preferably from the customer record that's currently open on my screen?. It illustrates how to use: Exact matches, Partial matches (wildcards), A range of values, Delimiters for. This month's article will focus on the process of resizing subforms on the main form, and the download is the same as last month's. How do you reference a control on a parent form from a subform? My subform is not tied with a unique identifier. sfrSubformB. In the subform's class module, you just refer to the Parent property; for example, Select Case Me. Accessing parent form from subform in Navision The Challenge. In our example we have a main form which shows the customers and the subform which shows all the orders for the customer: Independently the forms function by themselves, however it is more meaningful if they are combined. In order to reference a subform, you need to use the Form property to associate the form variable with the subform. I have a text box located on the main form. 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. Therefore, the width of a report should equal or narrower than a piece of paper (11" x 8. The Invoice form at the top of this page is a rough draft of what we really need. Item [Forms]![Name of the form your going to open goes in here]![The field name that the data will go into goes here] Expression [Forms]![Name of the form your taking data from goes here]![The field name where the data is comming from goes here] You also have to have an initiator to start the transfer ON THE ORIGINATING form. Open a Form from another Form (disabling the parent form until the child form is closed) in Access 2007 | 2003 Set the value of a textbox based on the value of another textbox in Access 2003 Set up a text box to display the difference between two dates in Access 2007 | 2003. The following is a condensed version of part of one of the VBA Lessons it should give you an idea of what events are and what they can be used for. Imagine a scenario where you are looking at a record displayed on a form. Microsoft Access Tips for Serious Users. An Alternative to Multiple Subforms in Design View for Faster Load Times This is the code-listing for video: MS Access Tab Control with Multiple Subforms. You have to call SetFocus twice: once to set the focus to the subform (on the main form), and once to set the focus to the control on the subform. Navigation Control - Subforms - Microsoft Access / VBA. That can be a nightmare trying to figure that one out. This script will read the ID of the parent from the Query String variable "IssueID" and then set the value of the Lookup field on the form to that value. Access Database Form Design. But there's a catch. I have a main form with 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. I would like to make the subform auto expand/shrink (downwards) depending whether there are one or four records required to display. I'd like to be able to select multiple rows in the datasheet subform and then change a value on each Get Selected Rows from Datasheet Subform - Microsoft: Access Forms - Tek-Tips. View Diana Shepard’s profile on LinkedIn, the world's largest professional community. Can anyone tell me how to change the source object property of a subform to achieve this using VBA code?. Get more from your data. MS Access - get value of a control on the parent form from subform I've got form and an subform. When naming forms and their controls remember that you must not include spaces in the name, or use any of the VBA "reserved words" (i. We are going to create three separate forms for a custom list. Send information to the people and places that need it by connecting your online forms to dozens of native apps or custom webhooks. Q: How can I run a report showing just orders from a specific customer - preferably from the customer record that's currently open on my screen?. This site uses cookies for analytics, personalized content and ads. We are going to create three separate forms for a custom list. 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. 0 and above. ]sbfControlName. Web Browser Control How to navigate to a different URL based on a subform value. It illustrates how to use: Exact matches, Partial matches (wildcards), A range of values, Delimiters for. When you have a form with a continuous forms or datasheet type subform, sometimes it is a good idea to highlight the current row by making its background a different color. Applied Partial Differential Equations with Fourier Series and Boundary Value Problems, 5th Edition. Pay once and get a cheap essay writing service without any hidden fees or extra charges. In Microsoft Access 1. You can add a subform to a form to provide related data from a one-to-many relationship. I have circumvented this problem by creating the relational model Grugeon described, and using this to create a table containing the required information to underly my subform. Our application has numerous subforms. A blank MS Access form is created with TextBox controls named for the columns returned by the temp table in the SQL Stored Procedure. ShowToolbar "Web", acToolbarNo. Create forms in minutes Send forms to anyone See results in real time. TEMPVARS Look Like The Secret In Access Services Web Forms. Any help is greatly appreiated. If the form is currently filtered (i. Form!txtOrderTotal. Adding that many can be a real drag on performance if you're not careful. There's a. The SQL statement that the Query Builder generated is now written into the Row Source property of the combo box. However, as you can see from the design-view image of the form below, there aren't any subforms embedded on these tab-pages. his new company has lost over 98% of its share value and for a time. OpenForm using FilterName. So technically, it could be argued whether this is actually a subform, or just a subdatasheet. Each navigation button on the navigation bar will displays a page of report or form that assigned to that button inside the unbound of Navigation Control area. Last thing is we have added a bit of visual basic code to the Sizes subform so that the form Total field will be updated instantly when anything is changed in the Sizes subform: Private Sub Form_AfterUpdate() Form_F_Order_Total_Price. Passing Data from One Form to Another Form: MS Access Nana Sara (Advanced Programming In Access 2013) Linking Parent Form Controls to Calling a Value from a Subform to a Main Form. In general it's not a good idea to access another form's control variables directly. Have questions or feedback about Office VBA or this. For example, the following code uses the Form property to access the OrderID control on a subform contained in the OrderDetails subform control. An information value dispersing candy for rehab people affiliated with these holiday cottages. I tend to get confused, so I will explicitly define the path when I'm using a subform. Using acDialog causes the form's Modal and PopUp properties to be set to Yes. MyLab Math for Quantitative Reasoning -- Student Access Kit.