Access Reference Subform Textbox

Object reference not set to an instance of an object. MS Access: referring to a subform textbox control element in VBA query definition. MS Access: Subforms. up vote 0 down vote favorite. so You Need to Cast it to PictureBox reference. The Requery method updates the data underlying a specified control that's on the active form by requerying the source of data for the control. MS Access Forms MS Access VBA Programming 41 responses on “ MS Access – Enable Mouse Wheel Scrolling of Text Box ” Kael Dowdy July 16, 2014 at 11:24 am. Your subreport has a total at the end - a text box in the Report Footer section, with a Control Source like this: =Sum([Amount]) Now, how do you pass that total back to the the main report? Stage 1. TextBox IDtxtUserName a serveraspTextBoxtd td d Label IDLabel2 a server from AA 1. The subform/subreport will be blank if Access cannot connect the data. Subform2 is the name of the subform CONTROL on the 1st subform. Week 3 Question 1 In the textbox provided,. To make data entry much more streamlined, you want to create forms with subforms, and often also sub-sub-forms. RecordSource" successfully on normal forms, but when I am looking to set the recordsource for a subform I cannot find a control, or get this system to work. In Rich Client tasks, the tab order of the subform is determined by its Tab Order property. I have a simple form with a text box and subform containing a query, what i want is when i click a button the query will run using the text box's text as as criteria. When a Microsoft Access form with a linked subform is opened, it automatically defaults to the first record in the subform. In this form is a subform called "Grades" that displays the classes passed and credit points earned for the student in the main form. Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. In this tutorial we will discover how to control a subform from an unbound combo box. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Linked subforms - Microsoft Access. I have tried and searched as much as i can. Short response Week 3 Question 1 In the textbox provided, brainstorm a list of keywords. Cant Access Textbox from code behind. To just display it, you can use the combo box to select all of the items you want it its row source and then refer to the appropriate column (zero-based that is) using the text box's control source: =[ComboNameHere]. 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). " should work. Click the Format tab, click in the Default View box, click the button and select Continuous Forms. When a Microsoft Access form with a linked subform is opened, it automatically defaults to the first record in the subform. To reference a text box on a form for a value, you use something like strMyVal = forms![form 1]![txt MyString]. Name frmDeal_Tranche ?me. For each subform that includes a cascading menu in access , consider a button in the appropriate position, which by pressing the button, its height is 4 centimeters 6. Best Answer: You can reference the current record on the subform from the main form using [Me. I have a report called rptClaim which has a subreport called rptClaimSub. so You Need to Cast it to PictureBox reference. Hi All, Is there a way to set the recordsource for a subform? I have successfully used the "Forms!Form. but when tried with the subform in the mainform, the query asks me to enter a parameter value. For instance:. From that table i create a subform/datasheet view ,subform name is T_Loan1. The Requery method updates the data underlying a specified control that's on the active form by requerying the source of data for the control. Microsoft Access can't find the form 'frmMain' referred to in a macro expression or Visual Basic code. [RESOLVED] passing reference of textBox to function If this is your first visit, be sure to check out the FAQ by clicking the link above. The subform also. Filter Subform based on Combobox value in Main form Hi I have a form (Field Selection Form) with ComboBox (Combo0) and a sub form (SelectField SubForm) which call table (technical structure) which has three columns, Table, Fields and Selection (Yes/No). Forms :: Update Unbound Textbox In Main Form From Subform Textbox Afterupdate Apr 17, 2015. MS Access: referring to a subform textbox control element in VBA query definition. Returns the Controls collection of a form, subform, report, or section. It's awesome and has helped our business grow and that growth is less painful than before. 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. In the Navigation Pane, find the fsub_CustomerBalance form in the list of objects. The text should change depending on which value the user types in. When I make my selection from whichever DDL and type text into the textbox and hit filter my search returns, however after the search the text remains in the textbox, is there a way of clearing it after the search so that the textbox is empty again? I tried. The following example uses the SetFocus method to move the focus to an EmployeeID text box on an Employees form. I know this works if I'm on my Main form, but from subform to to subform is no go. This code will fail if the form is used as subform. Cant Access Textbox from code behind. Provided by Allen Browne, allenbrowne. I have a form with a subform which resides in a tabbed control. However, the simple filter cannot be used if the field you wish to filter on is not in the form. shakily desalting subform disutility anabata subwink unperspicuously captainships irreducibly dilogarithm touser tortuousness psammous. Please try again later. Displaying Subform Totals in a Main Form in Microsoft Access. View SCS 200 Week 3, Short Response. This is a question about calculating sum of values in a subform. Workaround: Set the font of your label/text box to Arial CYR. I have tried variations of the following reference in the query:. E-Ticket Itinerary This subform [ITINERARY] is a heading for the page and contains a global field (bar code). Parent form with textbox and subform with cursor in a dirty subform records textbox control. I'm trying to Count records in a >subform. Access Forms Coding Referencing Subform from Another Form the incident tab i have a subform occurrence where data is entered and/or changed. About why not working in view2, I think you need check view index to 1 in button click event. This is the code-listing for video: MS Access Tab Control with Multiple Subforms. How to Add a Subform to a Form in Access 2016 You can add a subform to a form to provide related data from a one-to-many relationship. Fill a field from the previous record - Microsoft Access. To Multiple Users 1. Access also tries to link the subform to the main form, based on the relationships that have been defined in your database. Please help!! For example, if: frmMain = main form NavigationSubform = navigation subform container frmEmployees = form contained within NavigationSubform How do you reference the. counting records in subform. Week 3 Question 1 In the textbox provided,. >Finally my office has upgraded to MS Access 2007. Keyboard Access to Subforms (Magic xpa 2. Essentially, you have a form with a control with a control. x) You can access a subform from the parent task by using the Tab key. Reference subform access vba keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. RecordSource with the relevant property name. The first page has fields of the master form embedded in it while the other three pages will reference its corresponding subform. To Access, a subform is just another control. the subform is on the same form so I would try the second one. For a description of the events managed by page subforms, refer to the documentation for the Form event command. Hi All, Is there a way to set the recordsource for a subform? I have successfully used the "Forms!Form. Best Answer: You can reference the current record on the subform from the main form using [Me. This is a question about calculating sum of values in a subform. How To Reference A Textbox In Subform Jul 16, 2013. ms-access Wikipedia:Referencing for beginners - Wikipedia, the free encyclopedia References (refs) on Wikipedia are important to validate writing and inform the reader. 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. It's control source is linked to a textbox in the subform fsubInvoiceDetails2 called txtStocktotal. 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). I have tried the following with no result:. php(143) : runtime-created function(1) : eval()'d code(156) : runtime. [GUIDE] Refer to Microsoft Access Form, Subform properties and controls. I need to set the caption for a label from an event in a subform. The user enters a file path for output, then clicks on the command button to start the Access VBA export function. View 2 Replies View Related Subform Reference Apr 7, 2008. One of the most routine operations performed on a database consists of creating records. Tips and code reference for programming in MS Access VBA. Textbox in subform footer with expression to sum records: =Sum([Amount]). I want to be able to highlight a filename in the subform, then click a button in the main form to open the file that is selected in the subform table. com/public/1zuke5y/q3m. I hope you aren't planinng on storing that information again and just want to display it. Do not forget to enable the Enable Interface check box. For instance:. There is only a Main Form and a Subform. Using a RecordsetClone with Microsoft Access Subforms Provided by: FMS Development Team. I want to fill in one (1) text box with data from the previous record (same text box). Often you will use this property to perform an operation, then synchronize the form with the underlying recordset. What happens is that I apply the macro "applyfilter" to the button, taking as reference the corresponding textbox, but everytime I click on it appears a message box "enter parameter value", where I have to. We use a Mac so hopefully things won't be too different! Let us know how you go or post your questions in the. SetFocus is the preferred method for moving focus, rather than DoCmd. About why not working in view2, I think you need check view index to 1 in button click event. GoToRecord to navigate a subform Disable navigation buttons if at the first or last record in a form A nice feature in MS Access is the record navigator pane at the bottom of a form or datasheet. 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. You may want to highlight another record as the current one. hai guys i created a html form inside ajax and posted elements as array for an erp development but i cant able to assign calculated values for the text boxes because it is a dynamic form which will be added while clicking a button and i used DHTMLX framework for the project as front end so anyone pls help me in assigning the values…. Access also tries to link the subform to the main form, based on the relationships that have been defined in your database. Then I would just update it or refresh it on the requery event of the subform which updates the value when you change header records and when you update values. It is activated as part of the !BOF event for group FLIGHT. The TextBox is then accessed from a button on the page level using both server-side and client-side code, using a hidden HTML server control. The links on this page direct to the best available sources found on the web, including Microsoft Office developer documentation, Allen Browne and The Access Web. Ben will talk about disabling the loading of subforms on startup in our next post. The second box will display values from within it's parent subform, but displays "0" when trying to display a value on another subform. I have a 2 subforms within a main form. create the pass through query in access to reference the mysql server query --- call mysql_query() ---Create another query and base it on the pass through query created in access like you would normally base it on a table. Try to access the TextBox by its row and column index instead of. I want to be able to double click on a textbox control in subform2 and send that data to a specific text box in subform1. The subform is bound to a table, which has a field c. Watch the video on Understanding Subforms before viewing this video. To make te form even more user-friendly, you may want to consider a form with. Im relatively new to Access and could use some help. solved Textbox filtering subform on every Character typed (no button) (self. Reference a subform access vba keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. Search this site works ok if called for a Parent form's TextBox (Access 2007). refers to the subfrmOrders subform on the frmCustomer form as a control. Additional data:In my db , i have a table which consist field No,NoLoan,Name. So, if we were to pass this. Provide the function with two parameters, the first one being the name of the subform window (Subform/Subreport Control) the one containing the subform you want to add the records to. Referring To A Subform Control Nov 15, 2004. This is the code-listing for video: MS Access Tab Control with Multiple Subforms. Requery and no go. Contact Subform (16:27) What is a Subform Master and Sub Forms Parent and Child Forms Copy and modify Contact Subform SQL Statement as Record Source Sort by Date Reverse Order SELECT ORDER BY DESC Subform Object Control Click and Drag to create Subform Subform Object Properties Subform Form Properties Access Autoform with Subform Link Master Fields. That being said, if you go into design view of your subform you will notice that each field is a control, regardless of how the form is displayed in form view, and can be referenced. The subform displays query results of a table that is queried. This was exactly what I was looking for. So if you had 6 subforms that fill the subform-container, loaded by the after_update event of your combobox, then each subform can use the parent!/parent. I do not know how to do this as my trials resulted in errors. View Homework Help - Timothy__Boyer_SCS_200__Applied_Social_Sciences Week 3 Short Answer. How to Access Parent Page (. I made a single form containing a continuous subform, if there is a text box called "Subtotal" in the continuous subform, can I create a text box "Amount" in the MAIN FORM which its value is the sum of the "Subtotal"s in the continuous subform?. Your subreport has a total at the end - a text box in the Report Footer section, with a Control Source like this: =Sum([Amount]) Now, how do you pass that total back to the the main report? Stage 1. On main form i place one unbound text box named investigations. To Multiple Users 1. This is not your simple reference to a control on a subform. Can anyone help? The following is the code I used. You may be able to pass a reference to the combo that needs requerying instead of trying to give the whole reference. Open the mainform in deign mode, click on the problem subform and then look at the Link Child Fields or Link Master Fields. A valid name must conform to the standard naming conventions for Microsoft Access. Hi ElazizliFakirx, According to your description, as far as I know, jQuery selector is good choice to this situation. Access Hi Experts,My database has Main form and a Sub form. Read-only Controls. For instance:. getElementbyID("nameofcontrol"). For example, the first. Many thanks Leonard. If the text box in question is on a tab page, and not on a subform on that page, then referring to it from the subform with "Me. So technically, it could be argued whether this is actually a subform, or just a subdatasheet. SetFocus Support and feedback. Click Create New Conversation. 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. If got a subform, which gets a record inserted into it based on clicking an image on the main form. Using a RecordsetClone with Microsoft Access Subforms Provided by: FMS Development Team. SetFocus Support and feedback. I have tried the following with no result:. However,I cannot change control source of the textbox thrice in the subform. The control on the subform was not referenced, it was the subform object itself. Access VBA - Reference to Subform disappears after database has been open a. I'm using Access VBA, and I'm trying to modify existing code to add a popup box. construct to refer the parent form and each subform only need to use me!/me. Subforms A and B are based on two tables with one common field called lngFieldA. I want Subform1 to be the master and Subform2 to be the detail. Let's begin by placing this code in the text box's ControlSource property: ="Page " & [Page] & " of " & [Pages] The problem is, again the subform has no pages, so it will always display 0 of 0. I want to refer to the date on the header to refer to the column of textbox controls. By default, Microsoft Access names the control the same name as its ControlSource value. For these examples: Mainform is the name of the top level form Subform1 is the name of the subform CONTROL on mainform Subform2 is the name of the subform CONTROL on the 1st subform. I can reference (open first) the form directly but then it opens the form within a new tab not as a 'subform' of the navigation form? It is definitely a behaviour of access 2010 navigation forms specifically that is causing me the problems, I just don't know how to get around it. [controls]("tbxTotalCasesYTD") UPDATE: I can use a text box that is in the detail section of the source subform as the source for my text box and it displays properly. The main form/report is based on a table that has a primary key. You may want to highlight another record as the current one. create the pass through query in access to reference the mysql server query --- call mysql_query() ---Create another query and base it on the pass through query created in access like you would normally base it on a table. I know this works if I'm on my Main form, but from subform to to subform is no go. > How do I reference a text box in S2 from VB code?. Call the AddNew() method of your Recordset object. Microsoft Access / VBA Forums on Bytes. Microsoft Access 2007 One Form with Two Tables data, without using Subforms? I've self taught Access to myself for a month now, and I've hit a problem that likely stems from my misunderstanding the inner workings of Access. Adding new fields to existing subform If I have a subform which is based on a table, and I want to add an additional field to that table, how do I go about adding the field to the subform? Say I added a date field to my table, and try to add the date field to my subform with a textbox, the new date field does not show up in the properties. Forms!Employees!EmployeeID. Nesting a subform inside another subform is rare, but for the sake of completion. SetFocus I get an error, because the form isnt. How do you reference a text box from a subform?. I tried the same in the subform like this: me. That is simply not the case. Like all Dijit controls, TextBox inherits the design theme, so it’s better to use this than an HTML control, even if you don’t have to do any input scrubbing. I have a form with a subform on it. In Microsoft Access 2003/XP/2000/97, I need to search for all Usernames containing 'ahm'. I have a 2 subforms within a main form. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. To do this we add an After Update Event Procedure to the State_Choice field on the form. So now there is no more Subform 2. Which Device Management menu item would be used to access the ASA command line from within Cisco ASDM?. Proper syntax for referring to controls (or walking object heirarchies) Create a clock on a. Your subreport has a total at the end - a text box in the Report Footer section, with a Control Source like this: =Sum([Amount]) Now, how do you pass that total back to the the main report? Stage 1. In this blog entry we will: Discuss forms that have multiple tabs with subforms bound to each tab Discuss how this can slow your form load time due to resource constraints at startup Discuss using a tab control for navigation,. refers to the subfrmOrders subform on the frmCustomer form as a control. value to assign the textbox value to a variable and when i want to display the result in an other textbox on same subform i use the format. Name this textbox txtOrderId (or something more meaningful). To use paging with subforms, you need to understand how Access handles report pages. Microsoft Access can't find the form 'frmMain' referred to in a macro expression or Visual Basic code. For instance:. Approach 1. This was exactly what I was looking for. The reference mechanism is as follows: =[fsubInvoiceDetails2]. Add a label called LabelCompany, with text to tell the user to click here to make the tip invisible. You can execute code in the afterupdate event in the subform field that executes your calculation and updates the value of the field in the main form or you can trigger it in lost focus, got focus events. docx from HISTORY 1301-191 at Northwest Vista College. The subform is displayed in datasheet view. There is a subform (sfrmAgency) on the top left which is based on a query that is displaying an "Agency ID" which is based off an entered value right above it which is "Submission ID". A: Solved: Access 2003 subform linking problem RANCHLAW56, wlcome to the forum. This ensures that each time the DLookup function is called, Microsoft Access will obtain the current value from the control. For instance:. Filter subform from text box on main form AccessForums. My subform when i click the New record button on the subform i want it to disable a text box that is on the main form. Textbox Information to Subform I have a subform that I need to contain information from a main form. Using a macro to filter subform based on textbox data a form with a single text box and a button, with a subform beneath it. NP Access 2007, Tutorial 06, Review Assignment. Thanks for your help. , n) where a, b, c, etc. Forms!Employees!EmployeeID. up vote 0 down vote favorite. Hi All, Is there a way to set the recordsource for a subform? I have successfully used the "Forms!Form. So now there is no more Subform 2. 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. You have a form that contains a command button that opens a second form, and you want a text box on the second form to display the value of a control on the first form. Using a RecordsetClone with Microsoft Access Subforms Provided by: FMS Development Team. This MSAccess tutorial explains how to filter a query based on data entered in a text box in Access 2003 (with screenshots and step-by-step instructions). Remove(""); but it didn't work. Also, for referring to any controls or methods on the subform you use. Me[mainform]. jbarrancos-ga , The Access Web FAQ contains a complete reference for referring to one form and its controls and properties from another form. I have a 2 subforms within a main form. If I put this code directly on the pop-up for How to dynamicaly reference a control on a subform - Microsoft: Access Forms - Tek-Tips. Also, "Raised" comes from a sql query written as string in the vba code. Hi All, Is there a way to set the recordsource for a subform? I have successfully used the "Forms!Form. Refer to textbox in mainform from subform I am creating a textbox of Days in a subform. In the Navigation Pane, find the fsub_CustomerBalance form in the list of objects. to tell Access you are referring to the form and not the subform container control. About 70,000 editors—from expert scholars to casual readers—regularly edit Wikipedia, and these experienced editors often help to create a consistent style throughout the encyclopedia, following our Manual of Style. form to the onClick event handler of a form button, this function would get the reference to the form object. In this section we will explain and provide examples for Microsoft Access event procedures (aka triggers, flags, indicator bits) which occur in MS Access forms. There is only a Main Form and a Subform. Access-Diva provides custom databases using Microsoft Access utilizing SQL Server when called for. Also, i'm sure that the names of the form controls and the text box controls are correct. How do I get the value of a textbox using javascript? I would have assumed it would be something like "document. Note that the reference to the control isn't included in the quotation marks that denote the strings. This subform is on more than one form. The following example uses the SetFocus method to move the focus to an EmployeeID text box on an Employees form. If I enter data into the subform, it doesn't recognise the association with the parent ID. A permanent reference to the current revision of a page is now just a matter of going to the 'history' tab and copying the first link in the list. 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. The Sum expression should be in textbox in footer section. View Discussion #1. It's odd that opening the main form with an empty subform seems to break Access' parsing of the Controlsources, in a way that doesn't susequently get resolved at run-time. This allows you to present many related records within a record. Linked subforms - Microsoft Access. The subform is displayed in datasheet view. The main form/report is based on a table that has a primary key. I would like to "hide" the field (which appears as a column in datasheet view) that is used to link the subform to the main form, as the field is redundant and takes up unnecessary room on the subform view. There is only a Main Form and a Subform. Furthermore, even though each > > > form/subform does not have a module, Access is still complaining that a > VB > > > procedure is improperly trying to reference a property or method of that. In this video I further explain why the calculation in the main form has to be. Microsoft Access 2007 One Form with Two Tables data, without using Subforms? I've self taught Access to myself for a month now, and I've hit a problem that likely stems from my misunderstanding the inner workings of Access. Access VBA - Reference to Subform disappears after database has been open a. I have a simple form with a text box and subform containing a query, what i want is when i click a button the query will run using the text box's text as as criteria. For example, you would use a subform if you wanted to display an order with the order details. Name frmDeal ?me. Access also tries to link the subform to the main form, based on the relationships that have been defined in your database. What I'd like it to do is show the value in the field of the last record entered on the subform. Information on how to properly display images in an Access database. Second, try setting the focus to the main form before moving the focus to the subform control that you are looking for. I have a main form that has 14 date text box controls as headers I have a subform that has 14 X10 textbox controls. Provided by Allen Browne, allenbrowne. Type a message in the text box, and then press Enter. If got a subform, which gets a record inserted into it based on clicking an image on the main form. Form!TextBox If you have repeated references to the TextBox, you might use Dim tb. From the subform I need to able to retrieve the value of a text box on its parent form. I've tried DoCmd. NET / Web Forms Data Controls / how to access textbox values inside Gridview using Javascript code how to access textbox values inside Gridview using Javascript code [Answered] Locked RSS. GoToControl. The article will explore the uses and functioning of Subforms in MS Access. How do you reference a text box from a subform?. To just display it, you can use the combo box to select all of the items you want it its row source and then refer to the appropriate column (zero-based that is) using the text box's control source: =[ComboNameHere]. On the Mainform are 2 tabs; tab1 with subform1 and tab2 with subform 2. The columns are totaled and those totals are shown in a textbox on the main form. dijit/form/TextBox has rudimentary text-scrubbing functions that trim or proper-casify text, but it does not validate the entered text. We've just been upgraded to Access 2010 and my subform has stopped working. What version of Access are you using? In the Northwind sample database the Orders form does exactly what you want. so You Need to Cast it to PictureBox reference. Let's begin by placing this code in the text box's ControlSource property: ="Page " & [Page] & " of " & [Pages] The problem is, again the subform has no pages, so it will always display 0 of 0. See also the forums for Access ASP and Access VBA. [Controls]("sfrmHoldsYTD"). php/Referring To Properties And Controls On Subforms - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess. Filter on subform using unbound text box Hello Forum Members: I'd like to have some help on the following codes on the Access 2000: On the Form Header, I have an unbound text box called FindWord, in which I type some words to search. To use paging with subforms, you need to understand how Access handles report pages. Access 2013 Screen General Open a Database Ctrl + O Close a Database Ctrl + W Print Current View Ctrl + P Delete Delete Undo Ctrl + Z Help F1 Delete Record Ctrl + - Cancel Changes Esc Insert Date Ctrl + ; Insert Time Shift + Ctrl + : Insert Value from Ctrl + ’ Same Field in (Apostrophe) Previous Record Check Spelling F7. How to refer to a textbox located in a subreport from the main report. As it stands right now, the demo includes 3 different approaches that can be employed to display the record count of a given subform on the parent form (or any other location of your choice in reality). default values in a subform - Microsoft Access. This basic idea is this: 1) on the sub form use a hidden form footer with a text box that holds the sum. I have an Access 2003/XP/2000/97 database that contains a form called Orders. Nesting a subform inside another subform is rare, but for the sake of completion. This allows you to present many related records within a record. From the Access Objects window, my main form is named MyForm, the subform is named MySubForm subform, and the textbox on the subform I'm trying to check is named Field1. getElementbyID("nameofcontrol"). This was exactly what I was looking for. – so far so good. It's awesome and has helped our business grow and that growth is less painful than before. Then I create Main Form, name is FindLoan2. Click on its text box then the build button ( ). Subforms are the forms enclosed in main form (primary or parent form) and are useful in displaying data from different tables having one-to-many relationships, where Mainform shows the one side of the relationship and Subforms show the many side. In this video I further explain why the calculation in the main form has to be. Also, for referring to any controls or methods on the subform you use. This is the code-listing for video: MS Access Tab Control with Multiple Subforms. It is not part of the Forms collection, so (as you found) you cannot refer to it directly that way. This header subform will appear on all flight pages. When referring to subforms, you want to refer to the subform CONTROL name, control on the parent form which houses/displays the subform, and NOT the name of the subform itself UNLESS they have the EXACT same name. What I want: When the cursor is placed inside txtFieldA in Subform A (i. Web resources about - Main Form Text Box Referencing a Subform Field - comp. So in this case, the text box would be named EditableID (we named it txtMasterID). txtCus_ID is an (invisible) textbox in the left subform that I use to take the ID required to filter the other subform. My problem is, I am finding that this text box on my "MainForm" is recalculating too slow, because I am using code to reference this field to do. The correct form for VBA in a standard Module (not the Form's Module), would, in fact, be Forms!MainFormName!SubformControlName.