Access vba forms reference. Name © Accessing recordset fields in forms vs.

Access vba forms reference Action REFERENCE MAIN FORM CONTROL FROM SUBFORM 2 LEVELS DEEP Forms(Me. YourPublicProcedure But be careful there are a few gotcha's with Navigation Forms (as we have all discovered). Visible = True although your question is a bit confusing ("open a subform"? A subform is embedded in the parent form). when form 1's value changes set the property and get the property in form 2. Name Then FormExists = True Exit Function End If Next frm End Function Public Function getForm(strForm As String) As Access. , a field in the recordsource is not accessible in the form's/report's VBA code unless that field is the Oct 13, 2016 · Refer to Form and Subform properties and controls. expression A variable that represents a Form object. Mar 29, 2022 · If you want to refer to a specific object in the AllForms collection, it's better to refer to the form by name because a form's collection index may change. Provide details and share your research! But avoid …. name but you can't do that in a module. Properties(3) ' For the label name Forms(ctl. May 20, 2015 · I always follow the rule that if you are trying to change something in/on a form using VBA written outside of that form (i. CustomerID, 0) DoCmd. I don't have much experience with VBA. Recordset. Name & FormIDFormSep End If End Function Public Function GetControlByAddress(ByRef StartingForm As Access. ControlName. set Forms("NewForm"). ListIndex) I suspect that it is something to do with how I reference my forms and sub forms. But I have code that that finds which form is open, and then executes code from that variable, Oct 29, 2023 · When placed on a form used as subform, the form reference syntax you have will no longer work. In "References" (Tools > References > Browse), I've added in "Microsoft Windows Common Controls 6. Oct 2, 2017 · Your function should have just one argument as it is sufficent to pass only the subforms reference if you need that form NewRecord(frm as Access. They are to add colors and color codes to a vendor table when entering a new style. Forms. I have a form where an end user is able to add Training materials for a specific course. May 9, 2013 · Public Function FormExists(strForm As String) As Boolean Dim frm As AccessObject For Each frm In CurrentProject. I have searched several forums and have found related continuous form issues, but nothing that clearly addresses this Sep 12, 2021 · When you create a Reference object, you set a reference dynamically from Visual Basic. Column one's controls are named Color1, Color2, etc, and column two's controls are named Code1, Code2, etc. ActiveForm still references the form containing the popup button, even when the popup form has focus. MS Access VBA Control Events – PT3. You can easy refer to the mainform with Set mfrm = frm. Forms("Form1"). Form!LastName ' msgbox opens display content of LastName 'Move between records and click this button End Sub Full Form Reference. Form). Jan 12, 2020 · If you want to use such a strange/unusual way you can do it calling the subroutine whenever you want. – Jun 14, 2013 · Declaring and Setting Form Variable in Access VBA. Name © Accessing recordset fields in forms vs. Referencing the form itself can be performed by writing: Jan 9, 2012 · But I don't like having to name the form in the call. Recordsource in the Form_Open or Form_Load events is a way to avoid the initial (invalid) query in the subform. The AllForms collection is indexed beginning with zero. I want the user to be able to choose which form is top-most -- which means I don't want any forms set as Popup. I've used that to track down some of these form/subform reference issues. Using a variable to reference to a form in Access. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Apr 14, 2015 · I know how to refer to an item on a form by choosing the form, i. Oct 29, 2017 · On the main form: Private Sub OpenForm DoCmd. Value. Column( _ 0, Me. Controls("txtMemo_field"). Controls("Child0"). g. But, in order to set a specific property value of the form frm_TreeView_Example controls you can simply use frm_TreeView_Example. VBA Variables. Jan 21, 2022 · Office VBA reference topic. AfterUpdate; BeforeUpdate; NotInList . IsLoaded returned False. Action REFERENCE MAIN FORM FROM SUBFORM 2 LEVELS DEEP Forms(Me. My search showed that you can use the BoundColumn-property to change this, but I want to use the call in VBA itself. Jan 11, 2017 · It seems so simple, but I can't seem to find the correct syntax. , the Recordset of the Form), while "dot notation" (foo. 1. Can I use a variable as the name of a field in a form? 1. Unfortunately, I can't make them pass the references at all. When the forms initialize, the subform query is invalid, because the parent control is still invalid. AllForms If strForm = frm. This is your case: Forms!Mainform!Subform1. cbTable Form_Form1!cbTable Forms("Form1"). ControlName Private Sub cmdMyName_Click() MsgBox Me. Also, I want the Z-Order essentially preserved when a new Child opens. If I was doing it from a form object I would use me. If there is any other way around this I'm sure I can do that as I have spent so much time on it already! In a textbox on the form is where you write down the primary key your using then click submit. Nov 18, 2012 · My instinct would be not to bother updating txtCodePersonal for each keystroke in TxtFName. to the begining of each field with 1 being the starting iteration page. Ask Question Asked 12 years, 11 months ago. Count Forms("Form1"). The properties of the Forms collection in Visual Basic refer to forms that are currently open. Controls("textbox1"). Form!subForm2Name. Dec 8, 2009 · You could use Screen. Value Oct 2, 2015 · The subform control contains a form named fsub2 which in turn contains a text box named txtMemo_field. Form. Form!subFrm. Controls(ctlname). form Jan 21, 2022 · Use the Form property to refer to a form or to refer to the form associated with a subformcontrol. Mar 15, 2017 · I have built an MS Access Curriculum Management tool for my group at work. SourceObject = "CommunicationForm" [Note that Forms is the collection of open forms so you cannot use this to refer to a form in the Navigation Pane - unless you know that this form is open. expression. The code that I have is: Me!SystemLookup = Forms. Feb 16, 2018 · If the user selects a row, I want to return the value of the other (hidden) column of the same row. A control and a section on the same form can't share the same name. Name ' msgbox opens with the form’s name End Sub Private Sub cmdLastNameField_Click() MsgBox Me. Right now, in the test environment, the form in question is just a standalone, but for production, the form will be moved to a different form (thereby becoming Me. NotInList Continued . MS ACCESS FORM OBJECTS – PT2. in separate module or something) then you have to use Forms!myForm in order to go through the objects and allow access to find the form you want to reference as per the "not on these forms" quadrant on this cheat If you are on Download Doc version : Main form: Sub 1: To refer to a form property, like RecordSource : On Mainform: Me. Form reference technique in Access VBA. OpenForm "myForm" Forms!myForm. How do I reference the popup form in this case? So confused why Access doesn't register the popup with focus as the active form Feb 9, 2018 · I cannot get the reference from the list box though into the Txt box. AllForms(strForm). Form Object Referencing; Calculate Function . Feb 21, 2012 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Value and . An alternate syntax, valid for VBA only, is written like: Forms("frmMain"). Name Jul 28, 2008 · To Access, a subform isn't a form at all, but a control, so you must reference it as such. Let me explain. Feb 8, 2015 · You can only reference Forms![Customer Picker] when the form is open. Form dialogForm. Tag = Me. The second references the name of a property within a control. SetFocus. I have a table containing an ID and description and several other fields which correspond to settings for other aspects of the application; this table is the Row Source of the list box. RecordSource: Me. i have a button on the child form which needs to read a value on the parent form and use it i na calculation etc thanks Apr 30, 2019 · I need to find a way to make SQL pick up the data in a textbox on the form in MS Access. Dim Ctrl As Control Dim CtrlName As String Dim Counter As Long For Counter = 1 To 10 CtrlName = "P" & Counter Set Ctrl = Me. The more explicit method is this: Forms("frmBogus"). The following line is highlighted in red. Text Plus, Andre has also provided a great reference for Forms and Subforms - The Access Web by Dev Ashish. Access forms allow users to interact with data. Forms!frmMyForm![Control]. The intellisense knows what objects I'm referring to. Pass form name to second opened form via OpenArgs: DoCmd. Close an Access Form - save record before closing form, Ask the user for confirmation before closing the form, close all open forms, save changes to the Form object Using the Forms collection with an absolute reference to another form is often a sign that you could simplify things by moving the code into a different form/event instead. cboCollaboratorID = Me. net, c++, MS-Access) that is using the ACE database engine. Jan 21, 2022 · Use the Form property to refer to a form or to refer to the form associated with a subformcontrol. What I would like to do is use TempVars to store the names of the various forms and subforms and use them in the statement above. NavigationSubform. In general when one form launches another form in the 2nd form in the forms on-open event (in fact, you can even use as late as the on-load event) you can pick up a reference to the PREVIOUS form object. Recalc Form_MyTable1. Then the second form can reference the first: Microsoft Access Discussion. ] Jun 6, 2012 · Running a macro and opening the report with a where condition in which case Access would complain and say "[Reports]![AuditPTETotal]![Date] is not a valid reference" Setting the "where condition" of my report through VBA. Forms!NameofForm!NameofControl Jan 27, 2016 · I'm trying to reference a report object in some VBA code from a form object in Access 2010. IsLoaded Then 'If not yet open then You can't use "Form" or "Report" to name a control or section. References(1). ApplyFilter , "SurveyNumber = Feb 27, 2016 · From this old knowledge base article my guess would be this DLL is perhaps only included in older versions of Office? This part seemed promising: As an alternative to having your end users install Microsoft Office, you can have them freely download and install the Microsoft ActiveX Control Pad, which also installs the Fm20. Dim txt_id As Textbox DoCmd. Name. Controls are the building blocks of a form. Referencing forms with a space in the name in VBA I have a form called "Main Form" and I need to reference it in my Oct 15, 2014 · The data macro does NOT know or see application (vb. Instead, set the control source for txtCodePersonal to =UCase(Left([txtLName],6) & "_" & Left([TxtFName], 1)) That way, txtCodePersonal would be automagically updated to reflect completed changes to TxtFName or txtLName but the update wouldn't happen with each keystroke. Read-only Form. Parentform = Me. – There can be multiple instances of the Parent form, and each one can lead to multiple instances of the Child form (some background here). It works when I manually click on the option, but if I set it in the code nothing changes except for the option box selection. Syntax. 0. I think I have found more problems rather than a solution. You can call these functions anywhere in access. This path work if you are in the navigation form, but not on outside form. I am looking to create a form variable for an unopened form in my Access 2013 application so I can pass the form object to a series Dec 10, 2013 · You can use your string variable to refer to an item in the form's Controls collection. However, you can reference anything so long as it's fully qualified. This syntax will work whether or not form is used as subform. Activeform to get the form, or iterate through the Forms collection or, if the change is allowed, pass the name of the form to the function. Jan 21, 2022 · Use the Forms property to return a read-only reference to the Forms collection and its related properties. For example: Form_MyTable1. Jan 21, 2022 · In this article. CollaboratorID I call the form (CollaboratorEnter) from various forms and subforms throughout my application. Open an Access Form - using the DoCmd. Jul 21, 2014 · You can gain access to another forms controls by specifying the full path. Oct 15, 2010 · My surmise is that the introduction of support for ADO in Access forms/reports somehow decoupled the Access expression service from its connections to fields in the recordsources of forms/reports, with the results that you see, i. OpenForm "NewStockItemF", , , , acFormAdd, , CustomerInputID 'Code execution continues here after the called forms 'completes it all the events associated with opening (open, load, current ) 'so since the code keeps running you can set any property of any object in the called form Forms("NewStockItemF"). You need to call the item in the Forms collection (which are stored by name) varEnteredValue = Forms(frmname). To follow up on your edit: You're trying to use your string of the form's name as a form object itself. If the name of a control conflicts with the name of a field, I'm not sure which object is actually returned. Forms!frmCustomer!CboCustomer. 0 (SP6)" on a Form and given the control the Name "MyListView". At first I looked for the label among the properties of the textbox and struck out. I recommend adding a code module and creating some synthetic properties using public get/set functions and private variables. Form!Subform2. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Using the Forms collection with an absolute reference to another form is often a sign that you could simplify things by moving the code into a different form/event instead. expression A variable that represents an Application object. OpenForm arguments: view, datamode, filtername, where condition and openargs. Example : Forms!MyFormsName!MyControlsName. FrmSGSystems. subForm1Name. Aug 28, 2015 · In this article I will explain how you can reference access forms using VBA. OpenArgs "secondformname", , , , , , Me. UsedFields Then Ctrl. I have an interactive access form to filter a query by date range (start Date ex) 8/1/2017 and End Date) ex 8/31/2017) Then my query returns a single value: ex) 12345. Refer to an individual Form object in the Forms collection either by referring to the form by name, or by referring to its index within the collection. Properties(5). frmsocialgraph. With / End Jan 2, 2018 · What is the appropriate path to reference a sub-subform in a navigation form from outside form. Once you have the name of the form, it is easy enough to refer to the controls: Forms![Name of Form]![Name of Control] Or . One of the most ingenious setups is the main form Jul 11, 2022 · Object model reference: Provides reference materials for the Access object model. – Sep 12, 2021 · For example, the first code syntax returns the number of controls located on Form1. TextBox1. Column(0) So if you want to access a value in VBA that is contained in another form and use it as part of a query it would look like: Mar 12, 2021 · Me. Controls(subfrmname). Name). If you refer to a form by its index, the first form is AllForms(0), the second form is AllForms(1), and so on. It's read-only in all views. Requery Form_MyTable1. reports The default item of Form objects in Access is a union of the form's Controls collection and the form recordset's Fields collection. e. Controls("fldBogus") In order to reference a field using a variable, you can replace the pieces within (and including the) quotation marks. Controls. For example from form A your would write. name to return the name of the parent's form but it doesn't work if it's not attached to a control-here is a sample: The cornerstone of any Microsoft Access application is the form. Form Set FrmForm = m_objFrmForm End Property Public Property Set FrmForm(ByVal objNewValue As Access. Jul 8, 2014 · ctl. MS ACCESS FORM OBJECTS – PT3. Column(0) but that won't work. Form!ControlName. properties("LabelName") worked. OpenForm "frmB", , , , , acDialog,”Badger” Jan 17, 2019 · 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 I expect that p_ErmittleFrmZuordnung is located in the form Form_GUI too, so you can use Me to reference Form_GUI : Nov 6, 2014 · regarding your question. See also. May 28, 2015 · However when I set the values of the option boxes in VBA code (Me. Nov 19, 2013 · I would like to pass as an argument three parameters (userlanguage,the name of the parent form and the name of the grand-parent form name) I am able to do the two former but not the latter. Systemlist. But note the name of the subform (the form name not the control which contains it) does not appear in this statement: Forms("Form12"). Visible = True End If Next Oct 24, 2010 · Dim CustomerInputID As Long CustomerInputID = Nz(Me. MS ACCESS FORM OBJECTS – PT1. Dec 26, 2019 · Form frmA has a Public variable rsExample As ADODB. Report Mar 11, 2014 · I created a VBA function in Access 2010 which opens a progress bar in "Form!" and increases the size of "frame1" incrementally and updates a caption box. form. MyOptionBox = 1), there is no "update" to make the child option and combo boxes appear. . visible=True Jul 18, 2015 · I haven't been able to figure out how to reference this field. As an Access user and developer, you need to have a good understanding of how to reference the forms and controls you create. If it is included as a subform in some other form which is open, you can reference it via the name of the subform control on that other form: Forms![Other Form]![Subform Control]![Text8] Don't worry, I know that. This browser is no longer supported. Jul 24, 2014 · These forms open in design view might not have all their properties accessible. Form 'Verify that the name is valid first using FormExists If Not CurrentProject. [Pool eFile Attachment]. Setting the Form. Action REFERENCE PARENT FORM FROM SUBFORM Me. Because the employee_allocations_by_contract subform is a continuous form, a reference to the the employee_id field name appears to reference each row on the form. So if we run this test with your form open, and "orders" selected all 3 of these lines are equivalent. How to correctly refence the form from another form "Search", outside the Navigation form? Before I attached "frmVariants" to "NavigationForm" my code was: [Forms]![frmVariants]. Enabled so you probably want . dll. visible = False Jan 22, 2016 · When I click on a button that creates a popup form, my VBA code Screen. Form End Sub Or, to open a dialog form that's dependent on the main form: Private dialogForm As Form Private Sub OpenForm Set dialogForm = New Form_myForm dialogForm. expression A variable that represents a SubForm object. For the sake of this question, let's assume that frmName and rsName in frmB are String variables: 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. Asking for help, clarification, or responding to other answers. I am trying to program the WHERE-clause: variable = Forms!myFormName!myComboboxName. DoCmd. Modules & VBA . Forms!frmMainMenu!subFrm. Controls("Textbox1"). At the forms module level, for form I declare a form object as: Apr 7, 2021 · Me. Its ugly code, but trying to use . Parent. Isn't there a way to send the "current form" as a function argument? In VBA, you just use the "Me" keyword, for exampel "Me![Field1]". Usually it appends P<pageIterationNumber>. But at the end of the day, it works and its not slow. Width = 45 but before this can be done the Form_MyTable1 needs to be created. One of the fields in the form a Feb 8, 2012 · Access 2010 - reference form loaded by tab form. The Navigation form is named "NavigationForm". Name & FormIDHWNDSep & ParentForm. This property refers to a form object. If the form name includes a space, the Whenever you refer to a form or control, you use the Forms system object by placing the word Forms at the beginning of the reference. Hwnd & FormIDHWNDSep & ControlTarget. So, if you use: stFormName = "frmBogus" stFieldName = "fldBogus" [Forms]![frmBogus]![fldBogus] is but one way of referring to the "fldBogus" field. Value The cornerstone of any Microsoft Access application is the form. Support and feedback Nov 8, 2015 · I have an access 2007 form with 18 textbox controls in two columns. But you reported that CurrentProject. Problem: I cannot expressly supply the parameters. Remarks. Is there some other way to reference the current form in an expression? (It's a cosmetic question, I Sep 13, 2021 · Office VBA reference topic. Dec 1, 2001 · hi how do i reference a field on the parent form from the child form e. Form) Set m_objFrmFormu = objNewValue End Property Open the new form, and set FrmOldForm in new Form as the old Form. Action REFERENCE PARENT CONTROL FORM FROM SUBFORM Me. 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. Form) (note the strong name!). You need to open the form first before accessing its controls. in code it would be. Apr 7, 2017 · So go back and declare theForm As Object, and let VBA's late-binding magic query the object's interface, instead of working with the specific Form interface - again I don't know much Access, but it's fairly possible that Me being a specific form type exposes a Controls collection, but not the general-purpose Form type - VBA UI framework Apr 20, 2022 · Forms![frm2ProjectEnter]. AllForms("Customer Picker"). Access (Office client development) Support and feedback. Properties(3)). so that would be logically: open the form, access the control, change its property. In frmA, I open another Form (frmB). This tells Access that you are referring to a form, or a control on a form. Jun 22, 2011 · Personally I would pass them through the open arguments when opening the form. Forms![Nav Form Attachment]![NavigationSubform]. Oct 29, 2010 · I tried your very sensible suggestion. I understand that in a report, I can use the syntax Reports![report name] to reference the report named "report_name", but this does not seem to work from within form code. ForeColor = vbBlue Dec 28, 2012 · It's in a module because I have command buttons on all my forms that use the code instead of duplicating it within each Form Object. This forces your code to basically Jun 25, 2015 · I'm using Access 2003. The cornerstone of any Microsoft Access application is the form. Read-only Report. You have an Up arrow and a Down arrow on the references mini-form. FilterOn = True Jul 2, 2021 · form references are brittle. If anyone is able to assist I would appreciate it. Module 3 . Visible = False Else Ctrl. The commented line in my code should close the calling form before the home page is opened. thing) always refers to Properties, Methods, and Collections belonging to an object. For forms and reports, the Section property is an array of all existing sections in the form specified by the section number. <TemplateName>. ocx) and I've created/inserted an instance of the control "Microsoft ListView Control 6. ControlName This syntax allows you to use a variable as part of the reference The cornerstone of any Microsoft Access application is the form. You can use this way of setting in a module procedure, even before the form has been shown. Form) Private m_objFrmForm As Access. This property is typically used to refer to the form or report contained in Jul 24, 2014 · These forms open in design view might not have all their properties accessible. Control ' Given a control address and a starting form, this will return that control's Aug 11, 2022 · OpenRecordset to resolve the form reference in a query. Controls("cbTable") Notice at the top of all my modules it says Option Explicit. This is the window that appears every time you start Access. Your code; Mar 1, 2021 · GetControlAddress = ParentForm. You can also lookup values from other tables. Filter = Criteria [Forms]![frmVariants]. Item (1) Form_MyTable1. Apr 24, 2015 · It could be that you have a subform query that references a parent control. Hot Network Questions Mar 12, 2021 · I have a VBA module that contains a bunch of functions, and some of those functions are responsible for setting field values on a form. Controls(ctl. SetFocus End Sub Mar 17, 2016 · I'm currently working in access creating a database that will send all of the people I've designated an email every month with files relevant to them and am trying to reference a textbox entry where the user will enter a date from an Access form in an access module. Jan 21, 2022 · Refer to an individual Form object in the Forms collection either by referring to the form by name, or by referring to its index within the collection. A good analogy is the Access Database Container. So, if you use: stFormName = "frmBogus" stFieldName = "fldBogus" Oct 29, 2004 · I am trying to select one specific record from an open form and use that single value as the basis for running more code against only that single record. – Nov 20, 2014 · In this case "Bang notation" (foo!thing) refers to the value of a Field in the Form (i. But it seems like "Me" isn't accepted in an expression. Controls on the same form, report, or data access page can't have the same name, but controls on different forms, reports, or data access pages can have the same name. Running this function in "Step Into" debug mode produces the expected results (all macros run fine, dialog opens and updates etc. RecordSource Aug 21, 2016 · A form name is selected from the combobox and passed to a function as a string, using VBA (since don't know how to convert that string to Form). The Reference object is a member of the References collection. Use the Report property to refer to a report or to refer to the report associated with a subreport control. So, once the string value of the form is passed to the function I now have the string variable of the form I wish to do stuff to MS Access VBA Control Events – PT2. I keep getting a "Data type mismatch in criteria expression" error- anyone see a problem with this? DoCmd. 0 (SP6)" (c:\windows\system32\mscomctl. For example, Section(0) refers to a form's detail section, and Section(3) refers to a form's page header section. I tried using Me. Have questions or feedback about Office VBA or this documentation? [Forms]![frmBogus]![fldBogus] is but one way of referring to the "fldBogus" field. If you want to refer to a specific form in the Forms collection, it's better to refer to the form by name because a form's collection index may change. frmForm = me. [sfmProjectCollab]. OpenForm "frm_myform" Set txt_id = Forms![frm_myform]!txt_id txt_id. Apr 5, 2014 · When you manually examine the references, do you see anything like "missing" or "broken" in the dialog box that controls references? If not, try this: Select (by single click) the 7th reference. To refer to a particular Reference object in the References collection, use any of the following syntax forms. Synthetic properties are rock solid. Use the Down arrow to move that 7th reference to last. Load Recordset Values into Access Form. You obviously have experience in referencing sub forms in a normal Parent Form/ Sub Form relationship as in your code above but navigation forms are different in how they work and are handled. Since listboxes are together on same form, use instead: SELECT L1_Trend, L2_Subtrend FROM L1_L2_Mapping WHERE L1_Trend=[List35];. Jan 1, 2021 · Spawning pages from Template AND renaming fields: This is the default action of this function, it prevents fields from being linked to other pages. This can be done by following the steps below: – Contents Step 1: I would like to apply a filter to NavigationSubform "frmVariants". Microsoft Access VBA add data from form to tables unbound form. Forms collection; Forms object referencing . Caption ' For the label text In the Immediate window, using a text index instead of the magic number: ctl. Controls(CtrlName) If Counter > Me. Parent . 23; Run the VBA function. Forms are used to display and edit data, and to call other forms. So, Me!Controls equates to I have an MS Access form in which selection of a list box item determines how many other aspects of the application behave. Feb 8, 2017 · The SourceObject needs to be set to a string, which is the name of the form to use:. In other words, you can use a object approach here. Form!chkImport. subfrmAB. Tag and trying to reference the form the other ways didn't work for me after hours. The suggested workarounds are thus: Don’t reference the forms value, but ONLY reference the table column value (this assumes that the column is in the SAME table). Form Public Property Get FrmForm() As Access. It appears that when using the navigation form control only the form belonging to the currently selected tab is loaded, which means that I cannot reference the 'not loaded' form from the loaded one (active form running vba). The Forms collection is indexed beginning Working with Access Forms using VBA Opening and closing forms. Form, ByRef strControlAddress As String) As Access. Name Support and feedback. biaga gisgxluf ueceoj ubkduc ptwx yyspduw cwobbg wcyqhnf fum vcnhuyoq