Access vba form subform reference

Access vba form subform reference. Creating A VBA Sub Procedure. answered Sep 22, 2015 at 6:22. Me!Controls(strsubform). The fact that it is on a tab, for the code's sake is irrelevant. Jun 26, 2015 · My X form includes a subform control named Child1. My problem however comes with trying to reference the field in the subform. Requery. That is simply not the case. AllowEdits = True. Now I've saved a new renamed version of the form, changed the subform control to refer to a new form. Requery (or) Me. PUT_SUBFORM_NAME_HERE. SetFocus. The top subform is called FrmMonthDeptQuery and the bottom one is called FrmForecastDeptForm with source object ForecastDeptForm. RecordSource. [Forms]![frmMain]![NavigationSubform]. If you want to change the subform on the current mainform you need to change the sourceobject of the subform control. dbmitch. I don't use Navigation Form design. The exception is when the form loads, at which time Access prompts the user for QueryA's parameters. For example: where "Students" is the name of the parent form, "Grades" is Mar 24, 2017 · I am looking to create a single VBA sub procedure to change the . End sub. Print "this SomeRoutine in form " & Me. Requery does not alter subform properties . But note the name of the subform (the form name not the Apr 19, 2017 · In VBA you can refer to master form with something like me. The idea is - user inputs data in the table, then based on his typings, query runs, and produces data. In fact, if you check with allforms() the subForm isn't even loaded as far as access is concerned. Form! Sep 12, 2021 · For report controls, you can set the Height property when you print or preview a report only by using a macro or an event procedure specified in a section's OnFormat event property setting. You can also create a subform by dragging an Oct 2, 2015 · Instead of that, reference the subform control, and from there the target control in its contained subform. As you can see in Figure F, doing so updates the subform’s border properties. Unless you have subforms within subforms this is more than likely as bad as it gets. Use the Controls property to refer to one of the controls on a form, subform, report, or section within or attached to another control. DE. Form![control name] There's also a very good online article from mvps. so you probably want. For example, you might insert an OrderDetails subform into both a form and a report. (assuming the subform control has the same name as the subform) See Refer to Form and Subform properties and controls. Note that the expression used as the ControlSource of the text box in the parent form is = [sfcEvents]. This control has a " . controls [COLOR="Green"] 'find the subforms, and add them to the custom collection[/COLOR] if ctrl. Parent. QueryA uses a PARAMETERS declaration. CurrentRecord. forms! [MainFormName]! [SubFormControlName]. Both are were creetd using the form wizard and are bound by the column IXO_NR (on two different tables), which is the control source for a textbox on both the parent and subform. Forms![main form name]![subform control name]. If FormA's Controls have the same name as QueryA's parameters, this generally works. Source of one of the tabs is sfrmDS_Section_2 and its subform is called DS. Clicking the button sets the variable that I use to refer to whichever main form the button resides on. Subform. Otherwise the Case wouldn't attempt the recursive call. Mar 8, 2014 · Sometimes you may need to recreate the form by copying to text and then importing. Of course, if you need to do this in a Subform in that second form, you'd have to do things Jan 21, 2022 · Remarks. On the Form Design tab, in the Controls group, click the down-arrow to display the Controls gallery, and ensure that Use Control Wizards is selected. On the main form is a text box where I want to load a field value from the current record in the subform query. Aug 2, 2010 · Marshall Barton. Declaring Variables In VBA. #1. [Forms]! Mar 24, 2011 · @David-W-Fenton: I don't think that's quite right--or at least, the subform control is still part of the Controls collection, even if its form isn't loaded. Forms!frmMainMenu!subFrm. OpenRecordset("orders", dbOpenSnapshot) With rstEmployees. Name End Sub With the parent form (X) open in Form View, I can go to the Immediate window (Ctrl+g) and call SomeRoutine like this Jul 25, 2017 · It's meant to take tha value of that ID in addition to two other IDs, Cust_ID and Location_ID, and requery the subform Order_Sub within the Orders page. although your question is a bit confusing ("open a subform"? Jul 28, 2008 · To run the code, open the main form in Form View, and double-click anywhere in the header section. From a button on 'Custom Form 1' I'm trying to reference 'Custom Form 2' to perform a requery (ie. See full list on learn. so you need: Forms!mainFrm!subFormControlName. Generally the Form property of a subform control gets a "valid reference" only after the subform is shown. RecordSource = "(some sql text)" I read on one forum that Access can lose the reference to a hidden control after a period of time. 3. RecordSource = you have to make sure that subSubform is visible before the access is executed. Refer to Form and Subform properties and controls I'm glad this worked out. Several places in my database, I need to reference controls on subforms. Name. (Refer to Application. Form. controltype = acSubform then m_sfms. In this working example, Form12 contains a subform control named Child0. The code for this is: Forms![frm2ProjectEnter]. I'm trying to refer, using vba, from my one form to a subform many levels below: My current structure is: Navigation Control Form > NavigationSubform > Custom Form1 > Navigation Control Form > NavigationSubform > Custom Form2. I have a modal pop up with the name "sfrChangeProfilePics". [Subform Control Name]. I may not have grasped its full importance, but I have seen quite a few folks having trouble using it for anything signiificant. Make sure the subform CONTROL NAME, the name that it's named on the main form is used. This differs from the name of the underlying source form object, which is fsubEvents. – Jan 14, 2011 · SubformA uses QueryA, a saved query, as its SourceObject. Form2 is then supposed to open to a certain record and then filter the records shown on its subform all using value provided in Text0. Requery That affects Oct 15, 2014 · As shown in the code, we do only a subform . com Oct 13, 2016 · 1 Answer. The tab controls have nothing to do with referencing a control. A very common confusion when referring to items on a form is caused by the assumption that any Tab controls used are included in the reference. You obviously have experience in referencing sub forms in a normal Parent Form/ Sub Form relationship as in your code Apr 24, 2015 · Make a form with: A subform control that holds a grandchild form; A header section, height 0. ActiveControl. Subform "sfrProfiling" is contained within subform "Crafter Default" which is contained within "Main Form". Set dbcustomer = CurrentDb. The function steps thru each . The default name for new objects is the object name plus a unique integer. FormA contains Controls that supply the parameters to QueryA. Visible = True. Forms!Parent!child. . I've seen some threads on this but still can't seem to make this work. The following example uses the SetFocus method to move the focus to an EmployeeID text box on an Employees form. Or press the F9 key. (Subsequently, I've also deleted the subform control, recreated it with its original name, referenced The name sfrm suggest that the OP may be trying to post to a subform, which would need: Forms!MainForm!SubformControlName. RecordSource with the relevant property name. The intent was to default the subform's IXO_NR to the parent form's IXO_NR, then requery the subform to prevent the user Aug 3, 2006 · Aug 3, 2006. SaveAsText acForm ) Check for missing references (Code window, Tools --> References). Sep 22, 2016 · I traced the VBA code and it fails on the first line that references the subform: SubForm. So I either need a way to define an event function on a field in a Sep 6, 2018 · Another thing to try. 2. For example, the first code syntax returns the number of controls located on Form1. add Sep 22, 2015 · Set the query to the subform-recordsource in the form properties. I assume that is the case here, since when I reload the form, it works fine. Instead of creating the main form, and then adding the subform control to it, you can simultaneously create the main form and subform with a wizard. The subform control contains a form named fsub2 which in turn contains a text box named txtMemo_field. Nov 17, 2012 · The form's name is frmSearch The subform's name is SearchResults. cboCollaboratorID = Me. org with many examples that might fit your situations. The main form can reference a control on a subform with this style reference: Me. subform1. Form access as you do in. 2nd Subform in sbfrmPrimary: sbfrmSecon. If MsgBox("Sollen vorhandene Prozeduren verändert werden ?", vbYesNo, "Frage") = vbNo Then Exit Sub. Your situation sounds like an ideal use of the good old Tab Control. Subform contains a table with 1 column. End Sub. subform. Use the Visible property to hide a control on a form or report by including the property in a macro or event procedure that runs when the Current event occurs. subformcontrol. Control on the subform and performs a simple set of look-ups & actions. Sep 14, 2012 · 1. Here's what my mock-up of Form1 looks like: The Recordset property returns the Recordset object that provides the data being browsed in a form, report, list box control, or combo box control. When the button is pressed it is supposed to open Form2 that has a subform on it. Jan 17, 2019 · Then you can reference the subform controls by the name of the page and the static suffix. The following example displays the Name property setting of the active form. 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. LinkChildFields and . The subform control is selected. In the subform in a field called "End_Date" in the main form I have a textbox that displays the end date if there is one and then "available" if there isn't any. I have tried brackets and not, ! and . For VBA Code it would be: JanH = Forms!Main. [Form]![frmTSGroupList]. AllowAdditions = True. Apr 20, 2022 · Once the new value is added I close (CollaboratorEnter) and set the new value in the combobox on the subform to the value added. To refer to a control on the main form, you simply use [Control name]. You don't refresh the subFORM you refresh the subform CONTROL. Dec 21, 2022 · In this Microsoft Access tutorial, I'm going to show you how to sum up a field in a subform and display that on the parent form, instead of using the subform Jan 18, 2018 · 1. Jul 20, 2016 · 1. But let's say you have a formula in a subform control that needs to refer to another control in parent form (for example in a criteria), how can you refer to that parent control without using parent form name ? Jan 8, 2011 · The new Nav form serves some(?) purpose in web forms, but for anything beyond the trivial, I can't see a use for it in a traditional Access UI. Value. Main form - frmMain. You didn't say what your parent form name was, but you should be able to do it by using. control on sub -- [Section] From a form called frmStartUp (used to select a batch number and a section) this is the onClick event code: (the line in red is how I interpret the code from the table "Syntax Unfortunately, instead of showing the syntax for referencing a field on a subform, the systax shows how to reference a control on a subform. Form!Subform2. control1 or Me. Many times that is the same name as the subform Oct 23, 2010 · A form has a textbox (well, many textboxes) whose ControlSource is like. [?????] or more simply Me. The VBA Code Window. OpenArgs "secondformname", , , , , , Me. Sep 7, 2017 · I've made a simple database in ms access - made few tables, queries and so on. GoToControl "mycontrol". Hi, if the combo box is in the main form you can simply set the link properties of the subform control in the main form, i. This is your case: Forms!Mainform!Subform1. =MyVBAFunction (NameOfSubFormControl. The select_contract form: Is unbound. My code works as expected with the Form/Subform name hard coded; I am looking for a more generic approach. [control in subform] Answer. in design view of the main form click once on the subform and in the property sheet set its properties: Link Master Fields: [HereTheNameOfYourComboBox] Dec 15, 2016 · 4. The following example uses the Parent property to refer to the OrderID field expression A variable that represents a SubForm object. The fact that the combo is on a subform is not relevant in this case. The subforms name in my parent form is subForm2. In my case with 1 Customer - Many Orders diagram, I've a gain of time at the proportion of 2s over . [subform control name]. ColumnHidden = True. Nov 26, 2019 · 1. Next ctrl. parent. That would show any records containing the ID value from the first form. NameOfTextBox) No problems. Writing VBA Procedures. Controls. SearchResults. I've named the tab control pretty blandly, just tabCtl. I call the form (CollaboratorEnter) from various forms and subforms throughout my application. So from my main form I am doing: Call subForm2. sourceobject = "formName". RecordSource property (the grandchild). If you didn't change that name but named the Navigation form "frmMain" then the reference for the Filter would be: Code: Copy to clipboard. This returns the current record line number so I must be correctly referring to the form. Feb 3, 2020 · [Forms]![Navigation Form]. Or click in the left margin so that a reddish dot appears to mark the breakpoint. Filter = "ID=" & Tempvars ("ID") Me. [sfmProjectCollab]. I wish to access the selected value in it when I open another form in a new window using the below: DoCmd. In the subform I have: Private Sub USER_AfterUpdate() 'After update code. Jan 21, 2022 · For Access objects, the name may be up to 64 characters long. This property is typically used to refer to the report contained in a subreport control. Sub-Sub forms. I have a navigation form with a total of two buttons on the top. This should give a reference something either like. Controls (“MySubformControlName”) Then, we have to refer to the control on the subform itself. The wizard will set everything for you, but the rule for binding a control is to set the Control Source. Filter = "DUE_DT IS NOT NULL AND DUE_DT >= #" & (Date - 30) & "#" Form_subFormName. Feb 18, 2011 · Also, if the subform control name is different then you also need to include the . Even if you are in love with the Navigation Form, for doing the kind of things it appears you are trying to do, it's more flexible to use a set of command buttons that set a subform control's SourceObject property. This occurs in queries and in the vba behind individual Free Access programming tutorial Video 1. Control is called cboCustomer. May 15, 2016 · When you create a Navigation form and put your form in a tab your form ends up in a subform name NavigationSubform. For example, you can show or hide a congratulatory message next to a salesperson's monthly sales total in a sales report Mar 31, 2016 · Form Form1 has a textbox called Text0 on it and a button. I use it all of the time just to be explicit but if the names are shared then I believe you don't have to use it. Working With VBA Variables. TotalHoliday Aug 3, 2012 · 1. 4. But be careful there are a few gotcha's with Navigation Forms (as we have all discovered). e. Y is the form contained as a subform in Child1. Forms("frmCustomer"). Collection If m_sfms is nothing then [COLOR="Green"] 'on first reference, if the object doesn't exist, create it[/COLOR] set m_sfms = new vba. Form!TheAnswer. 1st Subform in frmMain: sbfrmPrimary. edited May 23, 2017 at 12:32. There is a subform in that form. Thanks! Oct 17, 2012 · Oct 17, 2012. However the format Me! [mainformname]! [subformname]. MainSub1Jan. To hide an object when printing, use the DisplayWhen property. I have the following: main form -- frmGenInfo. I need to reference a control on the form from the subform nothing works. Overview Of VBA Modules And Procedures. VB. enabled and . mycotrol. Set rstorder= dbcustomer. For controls, the name may be as long as 255 characters. Each button references a form. me. Form!ControlName. NavigationSubform. Forms. <br>LocalRequest is the main form, LocalSubformActions is the (contineous) subform, fldAction is the field I need to query. Whether an item (This includes, but is not limited to You can also move the focus to a control on a subform by using the SetFocus method twice, moving the focus first to the subform and then to the control on the subform. Unfortunately this one also doesn't work. You will see that second records subform is not requeried, just the first! Solution: Requery the control not the form with. Apr 28, 2016 · This is how to refer to subforms: Forms!mainFrm!subFormControlName. Dim sbfrm As Control. If a form is based on a query, for example, referring to the Recordset property is the equivalent of cloning a Recordset object by using the same query. Easy as that. You don't have to worry about using the tab control name in your code as all controls are referenced from their form or subform. This should be real simple, but is just not working. May 19, 2021 · For Each ctrl In frm2. form" must be included if you wish to refer to controls in the subform. That means you can employ Intellisense when you're editing VBA code within that form, so you can refer to the value of a control named control1 with Me. Dec 30, 2012 · MajP (TechnicalUser) 30 Dec 12 09:27. (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. After expanding first records subform, expand the second one (without setting focus to a control). NB. Text = Me. YourPublicProcedure. Dec 28, 2017 · Report abuse. Tag = "Hide" Then ctrl. In your button place vba code: Private Sub button_click() Me. Navigation controls are a NavigationControl and a NavigationSubform control grouped together, the buttons bar is the NavigationControl and the form container is the NavigationSubform. DeannaChris. Very simple. In a VBA sub run from the subform, "Me" would work as expected. Then the second form can reference the first: Forms(Me Nov 20, 2017 · Report abuse. part in the code. The first button shows the form. Keep in mind that no matter how many tabs are set up, only one subform is available at any time. Jan 7, 2013 · I have a Listbox object that is located in a subform in a tabbed form in access. Form! [subformcontrolname] is not recognized. Forms!Employees!EmployeeID. Jan 13, 2020 · Open the main form in design view. Something like. On the main form look at the label the subform wizard provided or select the subform by clicking once or on the border around it and look at the "caption" in the "Other" tab in properties. 5 inches; Add this form as a child in a parent subform control; The working case: Set the parent's subform height to . Remember we have to tell Access that Aug 5, 2010 · I would like to reference a subform within a subform from my main form's OnCurrent event procedure. Contains a combobox that allows the user to select a contract id. Enabled. Now, the area on a form that contains a subform is actually a control too: just have a look at it in design view. Refer to properties of a Parent form: Me. Apr 4, 2023 · Anyway, I'll start with some facts about what you want to do: 1. refers to the subfrmOrders subform on the frmCustomer form as a control. This is a database that may stay open on In this article we refer to Subform as indicating the control, and Sub-Form as indicating the form on that control. Right-click the existing form in the Navigation Pane, and then click Design View. So strsubform should keep producing something like "subDM1", "subDM2", etc, and then it's going to filter via the variable f. Form! [txtControl] Parent! Jul 18, 2015 · MS Access Scenario: I am using a form (we'll call it the select_contract form) and a subform (we'll call it the employee_allocations_by_contract subform). Sep 12, 2021 · Remarks. Nature of Navigation Form is that it loads and unloads subforms as called by click on tabs. Feb 3, 2017 · I am trying to write a macro that uses the "year" field value from the row that is currently selected in the subform. form " property which refers to the form that it holds. Click on the border of the subform so that it has an orange line around it. I assume you have done that already. FilterOn = True. We put those two together and we have: Forms (“frmTest”). Form Y includes this Public VBA procedure: Public Sub SomeRoutine() Debug. The employee_allocations_by_contract subform: Is a continuous form. Form!subFrm. The solution here is modify recordsource with each update using VBA instead of referring to the control in the query criteria. Requery Jan 14, 2016 · Try this in VBA, should work on every form or module you put it in: Form_subFormName. I can create the variable without a problem, but cannot Oct 13, 2015 · in ms access I have a form with a subform. SetFocus Support and feedback Nov 8, 2019 · A subform is a form sitting on another form (this is the 'parent') and opens when that other form (the 'parent') is opened and therefore is not a subform and does not have a parent. answered Aug 20, 2016 at 22:43. RecordSource = CustomerListFilter() Requery command was not necessary. This property is available by using a macro or Visual Basic for Applications (VBA) code and is read-only in all views. The idea is that I have one sub procedure that can be called by a button on any form in my application. Sep 12, 2021 · In this case, the main form can display the category ID, name, and description; the subform can display the available products in that category. USER_AfterUpdate. FilterOn = True Replace the subFormName in Form_subFormName with the name of your subform, but keep the Form_. So if I select the first row and run the macro, I want the macro to use the value "2019". Doubleclick through forms, loaded forms, the main form, the appropriate subform and then the actual control. To refer to it, use the name of the control. Any direction would be helpful. Parent!sfrReportPage!emailreport. Next, we already know that the subform container is a control. FormName syntax. So I think this is what you need: Declare a form variable in the Form_GUI (as long as you just reference the variable from code inside Form_GUI, it can be private): Private p_FrmZuordnung As Form Oct 17, 2014 · I decided to make a sub-procedure that accepts three arguments, their answer ("A", "B", "C" or "D"), the green image reference to make visible and the red image reference to make visible. I have been trying to use an iif statement for this. Microsoft Access automatically sets the Height property when you create or size a control or when you size a window in form Design view or report Design Oct 17, 2012 · In most situations, you would be much better off using a tab control so the subforms can remain open when different tabs are selected. However, unlike using the RecordsetClone Aug 4, 2016 · private m_sfms as VBA. This piece of code does not stop at the Subform to let me enter data. Now look in the form property sheet and note the name shown for the subform container (that's the main form control containing the subform). microsoft. The intellisense knows what objects I'm referring to. Replied on August 2, 2010. Remarks. To refer to other form properties replace . Recordset. Notes_Textbox. form. Use the Parent property to determine which form or report is currently the parent when you have a subform or subreport that has been inserted in multiple forms or reports. If ctrl. Nesting a subform inside another subform is rare, but for the sake of completion. collection dim ctrl as control for each ctrl in me. Filter = f. Feb 20, 2007 · In the controlsource of a control in the first subform, try invoking the expression builder. Pass form name to second opened form via OpenArgs: DoCmd. subform -- frmErrorRecs. Forms!Record_Details!Orders!Orders_Sub. To Access, a subform is just another control. This works just fine if I directly reference subDM1, but that's no fun. [Form]. Dec 28, 2017 · If that were the case, I wouldn't have needed to refer to the main form to begin with, since the referenced control is in the subform. Now add a record to table Sub with B as FK and then . Dim frmCurrentForm As Form Mar 23, 2014 · I will like it to loop back to the first order. to refer to the "parent" form of a subform, and then refer to a subform of the parent. DoCmd. Remark: in the above expression, sfrReportPage should be the name of the subform as a control on ReportCenter. For these examples Subform1 is the name of a subform control on frmMain, Subform2 is the name of Jul 11, 2017 · I recall reading that I do not need to refer to the actual subform directly on the navigation form but I just cannot get it to work. To do this i used this code: Private sub next_comp_click() [Forms]![Customer]![Compressor Subform]. Collection Property Get Subforms As VBA. On the Form Design tab, in the Controls group, click the Subform/Subreport button. if you want to open a form use the docmd. OpenForm "New form", , , , , acDialog Dec 27, 2017 · I am attempting to pass a form/subform name to a function without success. My form & subform look like this: To be clear, I'm using the "Search" button to create a string which contains the textbox and combobox values. CollaboratorID. subSubform. [main form name]. I have also tried Me!Subform with the same result. where subFormControlName is the name of the subform control (not the name of the subform) in the main form (it shows when the subform control is selected in the main form) edited Apr 29, 2016 at 1:00. LinkMasterFields, we gain about 8s for each real change of . This is usually the same as the name of the subform in the navigation pane of Access, but it could be different. As best as I can tell, the syntax begins as follows: Forms. Although, you may In cases like these you can reference the Navigation Sub Form by calling it like so: Me. Visible = False. I've tried. Apr 13, 2017 · reference a form inside a navigation form. So, let’s use the CONTROLS collection by utilizing Controls (“MyControlName”). For example, your subform contains a list of places by PlaceID and you wish to update it using a combo that shows the user a list of place names in a combo. Here is the code that isn't working. openform. Me. Jul 27, 2016 · Access Subform References in VBA Not Recognized. Fields ("Clerk"). For example, the first new form is Form1, the second new form is Form2, and so on. Dim rstorder As Recordset. You can only reference a form and its stuff when it's loaded. : Refer to Controls on a tabbed form. Refer to Form and Subform properties and controls. Form!chkImport. May 12, 2017 · Another technique is to set a break point on a line of your code. The second references the name of a property within a control. Value Each record in the mainform datasheet Microsoft Access / VBA. Hi, I have a form which contains a subform. Oct 2, 2016 · TempVars. Report abuse. 6 inches, so the child's detail section is visible; In code, refer to the child's subform. control1. Working With VBA Modules. For Each sbfrm In Me. --> Forms!Mainform!Subform1. Sep 6, 2017 · As a demonstration, I need a way to do this: Me. Unfortunately, I can't make them pass the references at all. subfrmOrders. Note from its properties sheet that its name property is sfcEvents . Sorted by: 1. A form can't have the same name as another system object, such as the Jan 20, 2009 · I have a subform whose record source is a rather complex unbound query. IMPORTANT: Do NOT click inside the subform. Dim dbcustomer As Database. ID) Now in the second form you can refer to that TempVars item, perhaps in the Load event of the Form: Me. asdev. #2. Probably. Mar 2, 2014 · 1. Or choose Debug->Toggle Breakpoint from the VB Editor's main menu. Jul 9, 2015 · In many situations, an Access form object lets you access its controls and record source fields as if they are properties of the form. I am using the following code as event handler for the button cmd_Edit on my main form: Private Sub cmd_Edit_Click() If intCanEdit = False Then. You can use. Example. Navigation form -NavigationSubform. This code from the subform works for getting the value of a field of the main form named "WorkSheet": MsgBox Form_WorkSheet. So far I've tried every way imaginable to reference the subform, but to no avail. I am trying to pass a variable from a Modal Form to a subform within a subform and unable to create the proper syntax. Filter. You can get very weird errors totally unrelated to the missing reference. Jul 7, 2009 · Jul 7, 2009. Add ("ID", Me. I also made a form and a subform inside that form. Caption. If your form has a subform placed on it, you can refer to the subform and its controls using an extension of the SystemObject. Dec 18, 2020 · I have tried a lot of options and the following I thought was the most promising. As Subform. 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. Requery instead of assigning a new . The Parent form is called MonthlyDeptTest but if I use that it says not recognized. The following example uses the Report property to refer to a control on a subreport. , Me vs full references, etc. Thus, if you want to execute a subSubform. I wanted to trigger an after update event in the subform using vba from the parent form. Private Sub Command38_Click() Me!SearchResults. This ". Currently I have a button with the code: Me!SubformName. Main Form: frmMain. Right-click on the code line, then choose Toggle->Breakpoint from the context menu. Form![Notes] I can access the subform fields AfterUpdate event within the scope of the subform but if I do that, then I can't access the Textbox because it is in the main form, not the subform. allowedit properties of all subforms of multiple a main forms. Alternatively, seeing the pop-up is being hidden, it can be referred to, so TheAnswer could be written to the Tag property of the pop-up and referred to from the main form. When you use the Reports collection, you must specify the name of the report. Nov 20, 2014 · strsubform = "subDM" & loopnumber. Referencing enumerated fields in sub-forms. You can use the ActiveForm property to refer to an active form together with one of its properties or methods. yy ot mc xk jr cg zy ho ri gt