Ms Access Subform Get Value From Parent Form

However, as you can see from the design-view image of the form below, there aren't any subforms embedded on these tab-pages. LinkMasterFields and LinkChildFields are properties of a subform control. MajP's DLookup() is missing a closing ")". 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. Provided by Allen Browne, allenbrowne. The form or report that contains a subform or subreport is called the parent. One of my favorite “tricks” in Microsoft Access is the ability to automatically fill a form based on either an entry or a selected value in a combo box…without using macros or VBA code! Of. To refer to other form properties replace. Elements is a subform of Subtask and Subtask is a subform. Hoping to get recommendations on the best way to filter subform records based on the criterion DueDate < now(). 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. Transferring Focus Between a Main Form and its Subform. In Microsoft Access 7. About 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. NoLoan Field value as i wanna clicked. For example, the routine might check if a user is permitted to view the form. Then, during runtime, the parent of the subform can invoke any of those functions with the Call Function system function. I've got form and an subform. In the two subforms scenario, the second subform is filtered on a value in the first subform. 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). In my demo, in the form which illustrates correlated subforms, the BeforeInsert event procedure of the second subform contains the following line: Me. Now, I decided I dont want to include subform A in the Form A. You need to rearrange the controls in the Detail and group footers to get them into a smaller space. 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. parent or DOM element, but still i couldn't access. The Filter property of forms (introduced in Access 95) makes it easy to filter a form based on a control in the form. In this case the answer is YES. - wbeard52 Sep 27 '13 at 22:16. How to Create Navigation Form: MS Access (Related Video) Overview: Navigation Form is a form that contains a Navigation Control. I have a form where I'm trying to filter the rows that appear in a subform based on a combo box in the parent form. After making a selection in the first combo box, Access asks for a value ("Enter a Parameter Value: Forms!MyFormName!FirstComboBox") for the first box when it tries to run the code above. Place a text box on the form Format it to display dates Enable the display of the Date picker. I specified the Master & Child Link fields on the sub-form Data Properties but this is. [Solved] Get Value of Selected Item in Subform. In this case, the main form can display the category ID, name, and description; the subform can display the available products in that category. 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. If you created a form from a table whose records are linked to another table, your form probably includes a subform. This is actually the 22nd release since the announcement of 0. I have a text box located on the main form. Hoping for a "one click" solution on the parent form, where the filter can be applied with one click and then removed with another click. Hence the name of this thread: "Filter/Search with Forms (leveraging SubForms). 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. I have a form where I'm trying to filter the rows that appear in a subform based on a combo box in the parent form. In those cases, use syntax like the following:. In that main/parent form i create text box, called Text7, and put T_Loan1 in subform object at footer. However, the simple filter cannot be used if the field you wish to filter on is not in the form. In this example, we have two forms - one called Orders and the other form called Order Details. The form expects an OrderID for both tables but that value is null so the item records cannot be related to the main order. From that table i create a subform/datasheet view ,subform name is T_Loan1. On the main form I have a combo box with 3 columns: Co Pass value of a combo box selection to a subform - Microsoft: Access Forms - Tek-Tips. A Subform Cannot Link to Fields in a Subform of its Parent. should do the trick. But,I said you canremember how to do this because there is an easier pattern to remember. How it Works. Do I need to turn on any object library references?. One option for information retrieval is the use of an Access query. Use the Syscmd function (or cycle through the Forms collection) to determine whether a form is currently open in design or runtime mode. Download Microsoft Access Database and Templates Examples for Ms Access 2007, 2010, 2013, 2016 Software. 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. For example, you can use a form with a subform to present one-to-many relationships, such as one product category with the items that fall into that category. If they are not, change the margins. It is placed within a tab control in the parent form. If you chose Use an existing report or form on the previous page of the wizard, skip this step and go directly to step 9. The subform is used to store the historical or dynamic data for a user from the tblempchange table. This form works perfectly on its own as a pop-up, but when I put it in another form as a subform the requery does not work right. Once the form is created, you can add or edit the query used to retrieve the. Hoping to get recommendations on the best way to filter subform records based on the criterion DueDate < now(). 0 of the Spine Parent Theme has been released and deployed to the WSUWP Platform. A Subform Cannot Link to Fields in a Subform of its Parent. For example, you can use a form with a subform to present one-to-many relationships, such as one product category with the items that fall into that category. Subforms in MS Access. The command button was located on a Customer Details form which had an Orders Subform in the lower section. One option for information retrieval is the use of an Access query. 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). Note that depending on how the subforms were added to the parent form, the name of the subform control may not be the same as the name of the form being used as a subform. Use the Syscmd function (or cycle through the Forms collection) to determine whether a form is currently open in design or runtime mode. You have to include the main form in the reference: [Forms]![main form]![my form]![my item] where main form is the name of the parent form, and my form is the name of the subform as a control on the parent form. After making a selection in the first combo box, Access asks for a value ("Enter a Parameter Value: Forms!MyFormName!FirstComboBox") for the first box when it tries to run the code above. 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. How to build a dynamic query with values from a search form in Access 2007, in Access 2003, or in Access 2002 Content provided by Microsoft Advanced: Requires expert coding, interoperability, and multiuser skills. I get a question about accessing from a subform control to main form control through vba. The following function can be called from the form (or subform's) Current event to limit the number of records to a specified maximum:. Access 2007 VBA Update Parent Form With Subform Combo Box Value I have an Access 2007 form [frmTrngRqmts] with a subform [subfrmTrngCourses]. Sub-Sub forms. I have a text box located on the main form. How to use Conditional Formatting for Subform or Datasheet Form. How it Works. I've got form and an subform. Subject: RE:[access-l] Eliminate the blank entry / record on Access subform. This particular code exclusively can be effective for a short moment associated with time. However I cannot get the form to refresh. It is read-only in all views. When using VBA code to set the focus from a main form to a control on a subform, one calls the SetFocus method. So for a full reference, you need to put that into the expression, instead of the name of the form being displayed in that subform:. In that main/parent form i create text box, called Text7, and put T_Loan1 in subform object at footer. Get Subform's Control In The Main Form. When closed, the app adds the Employee to the tabel to which the subform is linked. 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 to Get a Reference to a Subform's Parent Control. On the main form I have a combo box with 3 columns: Co Pass value of a combo box selection to a subform - Microsoft: Access Forms - Tek-Tips. The purpose of the subform is to allow the user to choose existing training courses that meet the criteria for the training requirement, since the requirement and the course may not have the same name. Applying a Filter to a SubForm External to the Parent - Microsoft Access. Often you will use this property to perform an operation, then synchronize the form with the underlying recordset. 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. Name Case "frmOne" ' Do one thing. I have a text box located on the main form. Setting the Link Master and Link Child properties will default the values in the subform to the values in the main form. A form will be created with a default name of Form1. When you are writing code for a subform, it's easy to get a reference to the parent form that holds the subform. In some applications, users were forced to navigate to one screen to add a record, and another to change existing records. The link fields are used by the subform to filter the records from the recordsource, and sow only the record that matches the parent form link field. The subform is used to store the historical or dynamic data for a user from the tblempchange table. How can I make the a value from a list box link to the form that the list box is on. They specify how Access links records in a main form to records in a subform. FormA has a combo-box with 2 values - 1 & 2. Most likely you will need to move some code from subform to main form. Navision has limitations when we you want GUI components communicating each other. For instance, the subform included in the Customers form we just created displays linked customer orders. 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. Access form showing event information in the parent, and related equipment in the subform Design paradigms of the 1980's and 1990's were largely data-centric. The reason I wanted to Enable or Disable the Command Button (located on the parent form), was that it was used to Delete the selected record highlighted in the Orders Subform's datasheet. If the user needs to add a new Employee, he clicks a button which opens the Employee entry form. I specified the Master & Child Link fields on the sub-form Data Properties but this is. If not, there is usually some numeric field on the sub that can be tested whether or not it is the field used on the main form. 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. From the subform I need to able to retrieve the value of a text box on its parent form. I would like to make the subform auto expand/shrink (downwards) depending whether there are one or four records required to display. Forms![ActivityLog_subform]![txtCalls] = Me. These functions will also work with normal forms, however, we are showing how to do additional things like: - Subclassing a subform in order to discern when an event on a subform fires. So, I thought I'd simply post a little MS Access Demo Database to show you how it can be done. I have a form / subform where the main form holds Company details, and the subform holds Contact details. Referring to Controls on a Subform. So for a full reference, you need to put that into the expression, instead of the name of the form being displayed in that subform:. The word "fields" is misleading because the fields may be be fields in your data source or control names on your form. These records never show up again in the subform, since they do not relate to any record in the main 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. should do the trick. Do I need to turn on any object library references?. Using a RecordsetClone is an easy way to manipulate records on a subform. How can I populate the list box (list 2) in subform from a value selected in a list box (list 1) in parent form? I can put in the row source of list 2 a query to match a table's field to the list 1. The primary form is called the main form, and the form that is enclosed in form is called the subform. The append query creates all related records in one step. Dim ctl As Control Set ctl = Me. So being completely new to Access I did some googling and it looks like this can accomplish this with some VBA. I have a form / subform where the main form holds Company details, and the subform holds Contact details. Lets say I have Form A and Subform A with the parent-child relationship established that works well. Microsoft Access is a database software application that allows you to create forms. This is the screenshot of how the final output should look. 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?. In the following example the ms access subform gets its value from parent form. I'd like to do something similar a subform but with the delete button on the parent form. MSAccess) submitted 4 years ago by xundria I have a form that is build to do a quick custom query based on field and input, I want to have the ability to export the result on the subform to an excel spreadsheet. Instead of Forms! let's use Forms() to get the form from the forms collection. In Access 2010, if you have a form with a subform in datasheet view, and you move the focus away from the subform, how can you tell which record(s) on the subform are selected? When the subform has the focus, the selected row is shown with a blue/grey tint. Note The Requery method updates the data underlying a form or control to reflect records that are new to or deleted from the record source since it was last queried. - wbeard52 Sep 27 '13 at 22:16. 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. Breaking news from around the world Get the Bing + MSN extension No thanks Add it now. The current form or report is disposed, and the form specified in. Keeping the subform control's SourceObject property blank avoids using a window handle until you actually set that property to a form object. MS Access automatically pairs the fields between the master (Parent) and child to filter the data in the subform. LinkMasterFields actually refers to a control name, not a field name. We found that if our users kept several parent forms open, they'd eventually get out of memory errors, due to each form and subform object consuming a window handle. How can I make the a value from a list box link to the form that the list box is on. Posted by grant-collinsworth on Aug 17 at 5:04 PM Mark as helpful. In this case the answer is YES. Now set the parent child relationship between the main form and the subform to be based on Table1_ID. If this is the standard, Access-generated Navigation form, then each form displayed by that form is really in a subform control named "NavigationSubform". I would like to create a text box in the form that I can search in the subform. I'll cover the following topics in the code samples below: Errorclass, Expression, Microsoft Access, Database, and Enter. Referencing to parent forms from subforms I have seen many help files for referencing to subforms from the main form, but not the other way around. The subform or subreport is called the child. The cornerstone of any Microsoft Access application is the form. sfrSubformB. I would like to insert the value from a bound control on a subform to an UNbound control on a main/Parent form. This is usually the same as the name of the subform in the navigation pane of Access, but it could be different. 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. Form!txtOrderTotal. No, there is no way to export data programmatically through the "Export Data" wizard in the Pervasive Control Center. Note that depending on how the subforms were added to the parent form, the name of the subform control may not be the same as the name of the form being used as a subform. expression. Add a second form by right-clicking the project and selecting Add, Add Windows Form from the menu. From that table i create a subform/datasheet view ,subform name is T_Loan1. First, set the modifier of your textBox to internal (or public if the child form you are showing is from a different assembly) of your parent form to expose it, so other forms can have access to it by using the parent form's instance. Value Any help , appreciated. Web Browser Control How to navigate to a different URL based on a subform value. Stop the Web Toolbar appearing when users click a hyperlink in an Access form. TripBoxSub is the junior subform and is linked to the Trip form by the ReceiptID. But,I said you canremember how to do this because there is an easier pattern to remember. The subform or subreport is called the child. Required, but never shown Post Your Answer MS Access sum of related records. Sometimes, we may have upwards of 5 or 6 subforms per form. Module: SubForms in Category Microsoft Access : Forms from Total Visual SourceBook General routines for Microsoft Access subforms (Jet and ADP) in Access VBA. pos_sts into an UNbound control on MainForm. One option for information retrieval is the use of an Access query. 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?. Dear Best STL, I've created a subform which will contain from one to four records. For example, the routine might check if a user is permitted to view the form. Becuase this is all very difficult to explain in words, please bear with me as I endevour to explain what it is I am trying to do. Now set the parent child relationship between the main form and the subform to be based on Table1_ID. The form or report that contains a subform or subreport is called the parent. subform should know nothing about main form and it should be up to main form to manage itself. I have a text box located on the main form. To reference a control on the Main form from a subform: Forms!MainFormName!ControlName Me. However, the simple filter cannot be used if the field you wish to filter on is not in the form. You need to rearrange the controls in the Detail and group footers to get them into a smaller space. 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. The form contains a subform displaying a number of related records summarized in datasheet view. The most up-to-date version of Microsoft Access is always available with an Office 365 subscription. We can create a query with one 'sum(tValue)' field but can't see anyway to get that displayed in a form. View 3 Replies View Related. The field on the main form or the field on the subform? You said you were updating the field on the main form, and you wanted its value written to the subform, right? So, obviously, the code would go in the After Update event of the field on the main form, not the subform, since that's the one you're updating, right?. How to Create Navigation Form: MS Access (Related Video) Overview: Navigation Form is a form that contains a Navigation Control. My apologies for any confusion. 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. When I had this all in 1 form it worked fine. Hi, I have a parent form with a subform in datasheet view. Controls are the building blocks of a form. A script is added to the on add ->on success of the "Student" form to send email with SubForm data. For instance, the subform included in the Customers form we just created displays linked customer orders. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Now, I decided I dont want to include subform A in the Form A. We can also pass multiple parameters to another form using this method, and the following tutorial details how to perform this task. Note that depending on how the subforms were added to the parent form, the name of the subform control may not be the same as the name of the form being used as a subform. You may then input who policy in the blog pertaining to access. We can also pass multiple parameters to another form using this method, and the following tutorial details how to perform this task. I want to save what the user types in a history of update parent form record from subform, without saving subform record. Transferring Focus Between a Main Form and its Subform. No, there is no way to export data programmatically through the "Export Data" wizard in the Pervasive Control Center. 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. We found that if our users kept several parent forms open, they'd eventually get out of memory errors, due to each form and subform object consuming a window handle. This time we will pick the subform icon to add to our form: This screenshot is from the Microsoft Access software program. OrderID The BeforeInsert event occurs as soon as a user begins to enter data into a new row in a form, so in this case, once the user selects a product in the combo box, the current OrderID value from the. 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. Limit the Number of Entries on a Continuous Form. The SQL statement that the Query Builder generated is now written into the Row Source property of the combo box. How to add a Lookup Control to a Form in Access 2016 Add a combo box that looks up data from another table, then displays meaningful text, rather than a number. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form. 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. Subforms are considered part of the main form and lose their own identity once they are loaded. Get Subform's Control In The Main Form. By pressing the [Tab] or [Enter] key within Access, you can move from control to. 0 of the Spine Parent Theme has been released and deployed to the WSUWP Platform. In those cases, use syntax like the following:. Duane Hook'D on Access MS Access MVP. The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet. Question: In Microsoft Access 2003/XP/2000/97, how do I link a subform to a form? Answer: To link a subform to a form, you need to create two forms - one for the subform and one for the master form. Web Browser Control How to navigate to a different URL based on a subform value. If this is the standard, Access-generated Navigation form, then each form displayed by that form is really in a subform control named "NavigationSubform". In that main/parent form i create text box, called Text7, and put T_Loan1 in subform object at footer. Dim varText As Variant varText = Me. Once the form is created, you can add or edit the query used to retrieve the. You could also set the default value of the control on the subform to pull the value from the main form. How to Get a Reference to a Subform's Parent Control. The parent is used to entry information regarding a computer. Applying a Filter to a SubForm External to the Parent - Microsoft Access. Forms coding - concatenating two fields from parent form to field in subform I have a form set up for data entry with a subform included. VB code to refer to a control on its "parent" form? I've had it, but I. I have a formset, a parent form with a child form. Pass Data To/From a Userform (A Microsoft Word Help & Tip page by Gregory K. LinkMasterFields and LinkChildFields are properties of a subform control. Add the subform at the bottom of the “Orders2” form. For instance, the subform included in the Customers form we just created displays linked customer orders. Save acForm, "New Employees Form" how can i use it to save both the main form and subform together. These functions will also work with normal forms, however, we are showing how to do additional things like: - Subclassing a subform in order to discern when an event on a subform fires. Forms coding - concatenating two fields from parent form to field in subform I have a form set up for data entry with a subform included. passing information from subform to main form? - Microsoft Access. 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. SetFocus method (Access) 02/20/2019; 2 minutes to read +1; In this article. I searched everywhere to find out a way to pass values but couldn't succeed. Author(s) Keri Hardwick: For these examples: Mainform is the name of the top level form. I want to retrieve fields from the parent form once a quick create form is opened. 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. In the two subforms scenario, the second subform is filtered on a value in the first subform. Therefore, the width of a report should equal or narrower than a piece of paper (11" x 8. com How to get the grand total in main form from subform. If you need to. Microsoft Access VBA Referring to Forms and Controls by FMS Development Team. Find out if a form is open. Change my parent subform control's SourceObject: If BrowseTo is called from a form that is hosted within a subform control and if the Path parameter is left NULL, then BrowseTo leaves the parent form in place and changes only the contents of the current subform control. To get things started, create the new project and add a new form. I would like to create a text box in the form that I can search in the subform. Limit the Number of Entries on a Continuous Form. How to refer to controls in a subform in a Microsoft Access database. Access Database Form Design. Forms![ActivityLog_subform]![txtCalls] = Me. Click on Mark Twain, get his books. For the experienced Microsoft Access user, navigating between main forms and subforms is an intuitive function. Of course the value in the subform control changes as you scroll thru records so the value in the UNbound Control on Main/Parent form should change accordingly. How to refer to a control on a subform from the parent form: Me. OrderID The BeforeInsert event occurs as soon as a user begins to enter data into a new row in a form, so in this case, once the user selects a product in the combo box, the current OrderID value from the. Additionally, subforms support the form-level properties: Update on Businessview and Fetch on Businessview. But,I said you canremember how to do this because there is an easier pattern to remember. I have found this to be the best test, since often it is a total or other number being passed back to the main form. Feb 21, 2005. I want Subform1 to be the master and Subform2 to be the detail. frmsubOrders. 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. These forms pull information from the database. A few days back, I was creating a small prototype for my project using MS Access. Setting the Link Master and Link Child properties will default the values in the subform to the values in the main form. Web Browser Control How to navigate to a different URL based on a subform value. The sub form is like a valid value table and I want to update a table that need the parent forms. This allows you to present many related records within a record. Get a Value from an Open Form Field Using Forms!FormName!Field Notation To Read a Form Value. Open the Orders Subform in Design view. It usually contains data that is relevant to the record that is currently open in the. Sometimes business rules mandate that there be no more than some fixed maximum number of records in a table, or related to a particular parent record. Therefore, you probably will need to create a form within Access 2013. Return value. "Parent" is a shortcut name much like "Me" is for the current form. We found that if our users kept several parent forms open, they'd eventually get out of memory errors, due to each form and subform object consuming a window handle. If that happens, they will probably get errors like these. MSAccess) submitted 4 years ago by xundria I have a form that is build to do a quick custom query based on field and input, I want to have the ability to export the result on the subform to an excel spreadsheet. (Advanced Programming In Access 2013) Linking Parent Form Controls to Sub-Forms - Duration: Calling a Value from a Subform to a Main Form How to Link Two SubForms: MS Access. Thanks a lot! Armando. 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. We have a parent form (Form 1) that contains a subform (Form 2). I have an Access 2000 main form "Main1" with subform "Sub1" and another main form "Main2" with subform "Sub2". These forms pull information from the database. Access 2007 I have a form and a subform. Linking Parent Form Controls to Sub-Forms video in the "Advanced Programming in Microsoft Access 2013" series hosted by Steve Bishop. They specify how Access links records in a main form to records in a subform. The sub form is like a valid value table and I want to update a table that need the parent forms. You can access the Property Sheet of the report then change the values of both the Height and the Width fields; As seen for a form, you can specify any width youo want for a report, but this aspect is subject to the printer. This lets you combine several reports into a. Approach 1. In my demo, in the form which illustrates correlated subforms, the BeforeInsert event procedure of the second subform contains the following line: Me. OpenForm using FilterName. The parent form (frmMainForm) displays the data in each record, which includes the ID of the father and the mother (who also have records in the table). use the afterupdate event of the record to transfer the data to the "parent" form's control. A Tree-View Control Using an MS Access Table and Form Shows the number of children for that parent. You could also set the default value of the control on the subform to pull the value from the main form. So being completely new to Access I did some googling and it looks like this can accomplish this with some VBA. These records never show up again in the subform, since they do not relate to any record in the main form. (Advanced Programming In Access 2013) Linking Parent Form Controls to Sub-Forms - Duration: Calling a Value from a Subform to a Main Form How to Link Two SubForms: MS Access. As part of the function call to NewItem2 we will pass in the the URL to the New Item form of our child list and pass the ID of the Parent item as a query string variable so that the child new item form can know the ID of the parent. expression A variable that represents a SubForm object. A field formatting by using VBA code will work most likely for a single form. Access-Diva provides custom databases using Microsoft Access utilizing SQL Server when called for. If you chose Use an existing report or form on the previous page of the wizard, skip this step and go directly to step 9. When closed, the app adds the Employee to the tabel to which the subform is linked. 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 might use this in a generic routine that does something with forms.