For example, you could have a form that displays an order, and a subform that displays each item within the order. Steps To Add A Subform To A Form In Access 2016. Making the subform control taller solves the problem. Access Subform functionality in Visual Basic Form If this is your first visit, be sure to check out the FAQ by clicking the link above. BrowseTo operates similarly but is much more flexible. As long as there is only one-to-many relations between the tables already defined in the page of relations, the fastest manner to create the form and its subform is using the tool of form. When the user open window in the big screen of monitor or change the screen resolution the frame of the Navigation Form or Sub-Form will not expand. Since Access calls all subform controls on a Navigation form "Navigation Subform", I'm not sure how to correctly reference a control on this form when I am not on the main form or the subform (i. This is just as true of forms in Access. Access will assume the Customer table fields should be placed in the new form because it is selected. In this course, you will be given the tools to become an Access 2010 power user. To make data entry much more streamlined, you want to create forms with subforms, and often also sub-sub-forms. The form is tied to the table so that any field that is new or changed is directly reflected in the table. This is a discussion on MS Access requery subform from another subform within the Microsoft Office support forums, part of the Tech Support Forum category. Why? Because they allow you to show related data easily. Referencing a control on an Access form is easy. You may find it easier to create the subforms separately and then add them to your form. This Query reads: "exec qryDonationsBeEvent '1/29/2008', '1/1/2007'" which executes a. By pressing the [Tab] or [Enter] key within Access, you can move from control to. I have a subform in my form that I would like to have as disabled or protected until the very end of the form. This allows the user to see on the subform only the lead analyst records they have been chosen from a drop down list on the main form. I have a form with a subform on it. Order Subform Create the Order Subform from scratch Continuous Forms Subform Control Turn off Navigation Buttons 5. There's nothing in any of the "On Click" type property boxes. We will also teach you how to create a subform in Access. If you change the subform's name, Access is cooperative and changes the references to it for you! Let's prove that! The main form and subform must be closed. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP. Forms are used to display and edit data, and to call other forms. However, the simple filter cannot be used if the field you wish to filter on is not in the form. The subform is on Form2. Jump to: navigation, search. The Navigation Form Control and Button controls cannot be created in code, so there is a degree of hard-coding involved. I have a main form (frmTitles) that holds the title (CD Title) information. /en/access/modifying-tables/content/ Introduction. [RESOLVED] Hide/Unhide Access Subform I have a subform on a form that I want to be hidden when the form loads and when the user clicks a command button to unhide. Tab1 contains Subform1, while Tab2 contains Subform2. Here's how you build a Navigation form: Open the database file that. MS Access Tab Control with Multiple Subforms. GoToRecord , "Subform", acLast but that doesn't work, nor does referring to the subform as Form_Subform or Forms!Form!Subform. The Enter event occurs before a control actually receives the focus from a control on the same form or report. Once you've created a form, you can also modify it by adding additional fields and design controls such as combo boxes. 1 is really two forms: the main form contains information about a. Controls are the building blocks of a form. I have searched the web, but unfortunately nothing worked out. ICT Training, Maxwell School of Syracuse University Page 5 Create a form by using the Form Wizard To be more selective about what fields appear on your form, you can use the Form Wizard instead of the various form-building tools previously mentioned. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP. Docmd GotoControl Access Example. Before using this feature, you should make sure that the table you want to use has a sub datasheet, which can be verified by the + button on the left of its records:. FilterOn not set/removed correctly for form and subform combination. On the Create tab, in the Forms group, click More Forms, and then click Form Wizard. The primary form is called the main form, and the form within the form is called the subform. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. Provided by Allen Browne, allenbrowne. The trick with the new Navigation Control in Access 2010 is to ensure that you refer to the form in their parent child relationship. Name, but it is a read only property. It is read-only in all views. Access Chapter 7: Creating Advanced Forms and Reports When a subform is created in a main form, a separate form object is created and displays in the Navigation. This code is good until you are using single form application. Any suggestions would be appreciated. To specify what subform gets loaded within the Navigation Form when you click a Tab, you select a specific Navigation Target Name. In this course, you will be given the tools to become an Access 2010 power user. Re: Tab Controls Disappear from sight in Form View BG44 wrote: Example: If your subform control (on a TabPage) is 2 inches tall and the form shown within it is 2. 1 A form's built-in Navigation Buttons. I have several subforms in a Navigation Form in Access 2010. Let us now take a simple example in which we. Question: In Microsoft Access 2003/XP/2000/97, how do I link a subform to a form? Answer: To link a subform to a form, you need to create two forms - one for the subform and one for the master form. Access reference navigation form subform 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. This is a good question. Enter event (Access) 02/10/2019; 3 minutes to read +2; In this article. I have a Navigation form named frmNav that on the first tab has. Access includes a Navigation Control that makes it easy to switch between various forms and reports in your database. How do I reference a text box in S2 from VB code? thanx alek_mil Try: forms!F!S1!S2!textbox That should do the trick -- Maurice Ausum "alekm" wrote: > Hi, > I've got a form F and subform S1 in it. Now you can see your new blank navigation form. If you do not see the subform in the Heirarchy then the count will be 0. USING MICROSOFT ACCESS 2013 Guided Project 7-1 Guided Project 7-1 For this project, you enhance the functionality of a database for a friend’s music collection. This doesn’t work at all, is there an easy way to fix this?. To open the physician form within the navigation form as a subform,follow the below steps and give the physician form properties in the subform while creating. When clicking on the main form tab it goes to subform but the scroll bar moves down only to show the. To do this we are going to use the example of a Customer Order form. You have to call SetFocus twice: once to set the focus to the subform (on the main form), and once to set the focus to the control on the subform. That means the Subform is actually avaiable in the form Heirarchy but you set the presence property to make it Hidden/ invisible. How to Make a Navigation Form or Sub-Form to fit on a various screen Setting. By tapping the Subform control and its Form property, you can perform many tasks, including enumerating the subforms on a form or summarizing the data in subforms into a control on the main form. I have the subform view property to "split form" and it fine when displayed as a standalone form, but when I drop it onto another form to be the subform, it only displays in form view. You can use an event of the form, a form. MS Access requery subform from another subform. (Always 1). To add a subform to a main form, go into design view of the main form; Drag a form to be used as a subform from the Navigation Pane. Showing or Hiding Microsoft Access Subforms: You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. Each subform control specified must be a. Navigation forms are a great addition to any desktop database. Below is a step-by-step guide to creating a form and subform from a table. Combining reports: An unbound report can be a container for two or more subreports, which do not have to be related to each other at all. As far as Access is concerned, an. Then just below HERE there’s a link to Pages, Posts and Categories – A complete list of everything that’s on the site. When clicking on the main form tab it goes to subform but the scroll bar moves down only to show the. I've got quite a few things to say about sub-forms, mostly be good. ms-access 42670 articles. [forms]![navigation form]. Forms: Refer to Controls on a tabbed form. I think the problem the poster is having is that even though his sub-form name is frmOvertime when it is put into the navigation form that replaced the old switchboard, it doesn't use the form's name as the default name for the form the navigation subform control's default name is literally NavigationSubform, so unless the poster changed that name to frmOvertime, it is not being referenced by. …And next I choose to build the subform…from a list of the fields in the selected form. [Solved] Macro to refresh subform by Nocton » Sun Dec 04, 2011 5:29 pm I have a table control on a subform ( subForm1 ) which I wish to update from a list box on the main form ( MainForm ) , which is subform of a filter form( FilterForm ). SetFocus method (Access) 02/20/2019; 2 minutes to read +1; In this article. When using VBA code to set the focus from a main form to a control on a subform, one calls the SetFocus method. Then select the style of navigation form to create from the drop-down menu that appears. In an ms access 2010 database, I have a listbox whose afterupdate procedure needs (among other things) to navigate to a specific tab in a navigation subform. datagnostics. I have several subforms in a Navigation Form in Access 2010. /en/access/modifying-tables/content/ Introduction. It will again keep the tabs at the top, but you could size the form/subform to the necessary size. Visible = False Then DoCmd. As long as there is only one-to-many relations between the tables already defined in the page of relations, the fastest manner to create the form and its subform is using the tool of form. Now, however, it is asking for Parameter Values when I select the items in the combo box. A one-to-many relationship is an association between two tables in which the primary key value of each record in the primary table corresponds to a value in the matching field or fields of many records in the related table. When you open a form from the Navigation Pane, it is positioned from the top-left corner of Microsoft Access. I use Access 2016. Since the subform inherits the permissions of the main form, you may not want to check the subform. Access makes it easy to create a form from any table in your database. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. On the Create tab, in the Forms group, click More Forms, and then click Form Wizard. For example, the routine might check if a user is permitted to view the form. Hide a subform in MS access. Modifying and Working with Subforms MS Access tutorial. Type the label you want, and then press. Problems and orders are contained in a subform. Since Access calls all subform controls on a Navigation form "Navigation Subform", I'm not sure how to correctly reference a control on this form when I am not on the main form or the subform (i. So, I thought I'd simply post a little MS Access Demo Database to show you how it can be done. The trick with the new Navigation Control in Access 2010 is to ensure that you refer to the form in their parent child relationship. Create a New Form. This article shows you how to reach Access form Nirvana: a situation where you have a set of navigation buttons at the bottom of each form, which you can freely copy and paste without worrying about whether the code behind them will work. And third, the subform container control will let you swap out subforms as you desire. (If you don't see it, press the F11 key. To refer to a control on the main form, you simply use [Control name]. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Unloading the subform on a parent form's Current event would be too late because the navigation would force the linked subform to re-filter. hello there, After watching you're video about linking two subforms i tried this with a subform and a navigation form (entered as a subform). In this Microsoft Access video tutorial, you will learn about Main Menu Form, Build a Main Menu, command buttons, form properties, customer list form. At this point, save the navigation form. The subform is displayed in Datasheet view, just like a regular table or query results. I have the subform view property to "split form" and it fine when displayed as a standalone form, but when I drop it onto another form to be the subform, it only displays in form view. There's nothing in any of the "On Click" type property boxes. Viewed 13k times 9. Whats the best way to do this?. Since there are several ways of adding a subform depending on your needs, for more information, see the article Create a form that contains a subform (a one-to-many form). com (please reply to the newsgroup). In the following example the ms access subform gets its value from parent form. By pressing the [Tab] or [Enter] key within Access, you can move from control to. Click on simply the primary table in the square of navigation, and then on the label of creation, in the group of forms, click the button of form. We need to be able to reference the subform control from the main Microsoft Access form. Passing an ID/value to a subform. In our example we have a main form which shows the customers and the subform which shows all the orders for the customer: Independently the forms function by themselves, however it is more meaningful if they are combined. The cornerstone of any Microsoft Access application is the form. I am ok with designing the forms around a common resoultion. I have a subform on one of the tabs. Access 2007: Refering To A Control On A Subform Within A Form On A Tab Wow! typing that heading is more complicated that solving the problem! I have a main for that contains a number of tabs (let’s call the form “frm_MainForm”). Active 3 months ago. The trick with the new Navigation Control in Access 2010 is to ensure that you refer to the form in their parent child relationship. This article is part of the To Base and Back Again tutorial series. I would like to have the user be able to "Add a Record" to the subform. There is no link between the main form and subform. a form put on to a navigation form becomes a subform. To make data entry much more streamlined, you want to create forms with subforms, and often also sub-sub-forms. Viewed 13k times 9. Relational data refers to the one-to-many relationship between records that are stored in separate tables. Learn to create pivot tables and pivot charts and be introduced to SQL statements. Whenever you create a form that contains foreign key data, you will need to decide which value to display to the user — the foreign key value (usually a number or code), or a. This doesn't work at all, is there an easy way to fix this?. properties, you must use a form as the subform control's Source Object. Now switch to Form View to see how it's displayed to the user. Tried many options but could not figure out what is going wrong. This is a good question. Filter a Form on a Field in a Subform. How do I do that?. For example, the routine might check if a user is permitted to view the form. Highlight the Customers table, and click the Form button in the Forms group on the Create tab. The subform's SourceObject points to an existing PivotTable Form, whose RecordSource is an Access Query. This article is part of the To Base and Back Again tutorial series. Whenever you create a form that contains foreign key data, you will need to decide which value to display to the user — the foreign key value (usually a number or code), or a. I need to navigate > using the tab key from the end (last control) of one subform to the first > control on the next subform. Access disables the Previous and Next buttons on the record navigator by default if you are at the beginning or end of a recordset. Author(s) Keri Hardwick (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 naming the form, I can switch to. Such a macro does not appear in the. But there's a catch. I use Access 2016. The subform creates a continuous form of a recordset. Or, you could have a form that displays a country, with a subform that displays each city within that country. Showing or Hiding Microsoft Access Subforms: You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. This property is typically used to refer to the form or report contained in a subform control. Any suggestions would be appreciated. As we shall see, it is a convenient way to navigate between forms when there is an underlying Many to Many Relationship structure in place. After the 2nd submit button is used I'd like the reciever of the form to have access to the disabled subform. Once you've established the table relationship, Access makes it easy to create a subform. The issue I am having is that when I click the 'Close' button I can remove the fields from the subform but I can't close the subform and redisplay the 'Add', 'Edit' and 'Exit' buttons on the mainform. Hi All, Is there a way to set the recordsource for a subform? I have successfully used the "Forms!Form. com reaches roughly 310 users per day and delivers about 9,287 users each month. You can use the Form Wizard to help you create subforms quickly. If you change the subform's name, Access is cooperative and changes the references to it for you! Let's prove that! The main form and subform must be closed. "Search" is not the target of the button. If I enter data into the subform, it doesn't recognise the association with the parent ID. It is not always necessary to create a separate form object to display related data. To open the physician form within the navigation form as a subform,follow the below steps and give the physician form properties in the subform while creating. By joining you are opting in to receive e-mail. That subform also has tabs on it. The subform creates a continuous form of a recordset. Dear Expert, Here the Navigation form and its subform, when I selec "Return Hired Item" and click on the button "Return" then I want to refresh the form or re-query using VBA code because the "Return" button execute many other process. There are different ways of hiding or displaying a sub form in Microsoft Office Access. 9 The wizard has produced a form that displays the plant names in a subform. I have a subform which I filter from a main form, when I export the results through a query I don't always get the same records that are shown in the subform. Any suggestions would be appreciated. That means the Subform is actually avaiable in the form Heirarchy but you set the presence property to make it Hidden/ invisible. I think the problem the poster is having is that even though his sub-form name is frmOvertime when it is put into the navigation form that replaced the old switchboard, it doesn't use the form's name as the default name for the form the navigation subform control's default name is literally NavigationSubform, so unless the poster changed that name to frmOvertime, it is not being referenced by. A subreport can be put on a form in Access 2010, 2013, and 2016 but not in Access 2007. There is no link between the main form and subform. Don't confuse the Navigation form with the Navigation pane. In this tutorial, we will teach you how to create a form in Microsoft Access. I currently have a form that contains a subform, which has 4 subforms in it. By joining you are opting in to receive e-mail. There are some work. -- Dirk Goldgar, MS Access MVP www. In the first tab of the navigation form, there are (3) subforms which contain data from five separate tables, all of which share a 1 to many relationship among themselves. For example, try something like: WHERE qryActiveInactiveEmployees. In this example, the Main Form is the top level form in the Access client application. Access includes a Navigation Control that makes it easy to switch between various forms and reports in your database. access the Form Navigator from the form design toolbar. Using a RecordsetClone is an easy way to manipulate records on a subform. ) and I can't find the original VBA code/macros that are driving Access' navigation forms. And third, the subform container control will let you swap out subforms as you desire. Subform Totals Showing the Totals in the Subform Footer More with SUM() Function Get Line Item SalesTaxRate from Order Form Create a Button to Show Orders Only for Current Customer Sales Tax Rate Per Customer, Per Order. So for a full reference, you need to put that into the expression, instead of the name of the form being displayed in that subform:. How to Use Navigation Where Clause. Subforms rarely come out the way you want them to the first time: They may be too small or too large and must be resized so that the main form and subform fit together nicely. My issue is this: I need to get the sum of all the sub-subforms for each subform, and then the sum of the subforms that belong to the main table. To continue with your YouTube experience, please fill out the form below. *Tek-Tips's functionality depends on members receiving e-mail. Enter event (Access) 02/10/2019; 3 minutes to read +2; In this article. This section will focus on more advanced things that can be done with forms. In the left Navigation. com (please reply to the newsgroup). Microsoft Access is a database software application that allows you to create forms. In this example, the Main Form is the top level form in the Access client application. In an ms access 2010 database, I have a listbox whose afterupdate procedure needs (among other things) to navigate to a specific tab in a navigation subform. The same methods for creating and managing apply, for the most part. So for a full reference, you need to put that into the expression, instead of the name of the form being displayed in that subform:. 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. One of the forms includes a combo box and a command button which, when clicked, opens a report filtered based on the value in the combo box. When wanting to use any of the controls, methods, or properties of the actual subform, you must use. The Navigation Buttons, Record Selectors, Close Button and Control Box are all set to "No" on all forms. How to Create a Navigation Form in Microsoft Access. Tab1 contains Subform1, while Tab2 contains Subform2. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP. When using code to refer to the subform, you use the subform. Steps To Add A Subform To A Form In Access 2016. com uses a Commercial suffix and it's server(s) are located in N/A with the IP number 204. Navigation forms can be used to quickly display forms and reports within a form. Showing or Hiding Microsoft Access Subforms: You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. ) and I can't find the original VBA code/macros that are driving Access' navigation forms. Whats the best way to do this?. Saving records on Access subforms If this is your first visit, be sure to check out the FAQ by clicking the link above. I want subform2 to be related/influenced by subform1; so that a record shown/selected in subform1 results in the related records in subform2 to be shown. Steps To Create A Subform From A Table In Access 2016. I have a subform for storing patient data that is linked to the master form by the patient identifier number. Creating A Data Entry Form With A Subform. A navigation form is simply a form that contains a Navigation Control. As long as there is only one-to-many relations between the tables already defined in the page of relations, the fastest manner to create the form and its subform is using the tool of form. By tapping the Subform control and its Form property, you can perform many tasks, including enumerating the subforms on a form or summarizing the data in subforms into a control on the main form. Subform1 is the name of the subform CONTROL on mainform. A subform is a form within a form. Will post it as soon as I get around to it! In the meantime you might find this article interesting:- MS Access your Data with Sub-Forms. I want the subforms to be linked to the masterform. How to Use Navigation Where Clause. In the Navigation Pane, right click on the new form, Subform-Clients-Staff-tabcontrol. When wanting to use any of the controls, methods, or properties of the actual subform, you must use. The following code example demonstrates how to use the OnCurrent property event procedure of the subform to display or hide the scroll bars: Private Sub Form_Current() ' If the number of records in the subform ' is greater than 2, display the ' horizontal and vertical scrollbars. The term unbound means that the form is not bound to a particular Table as with conventional forms. And third, the subform container control will let you swap out subforms as you desire. The form is tied to the table so that any field that is new or changed is directly reflected in the table. 1 is really two forms: the main form contains information about a. The form can be displayed in:. If I have the navigation subform correct, it's like it can't find the fields on the original form. Since there are several ways of adding a subform depending on your needs, for more information, see the article Create a form that contains a subform (a one-to-many form). Ms Access Listbox With Checkboxes. A single subform is designed like a regular form where fields are created in the Detail section and other optional controls can be added to the other sections of the 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. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. access the Form Navigator from the form design toolbar. Sample Database: LinkingTwoSubforms. A subreport can be put on a form in Access 2010, 2013, and 2016 but not in Access 2007. zip (26K) Microsoft Access makes it easy to see related records on forms. Displaying Subform Totals in a Main Form in Microsoft Access. Question: In Microsoft Access 2003/XP/2000/97, how do I link a subform to a form? Answer: To link a subform to a form, you need to create two forms - one for the subform and one for the master form. 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. Unless you have subforms within subforms this is more than likely as bad as it gets. Therefore, I had to first remove the navigation subform and the navigation buttons or the form would show on top of any other Access objects under the other buttons. This article shows you how to reach Access form Nirvana: a situation where you have a set of navigation buttons at the bottom of each form, which you can freely copy and paste without worrying about whether the code behind them will work. If you explore the new Access 2010 templates you'll find these all use the tabbed Navigation Forms. VBA Record Navigation in Subform Now the only problem I have is that my main form and subform are linked by the leadanalyst field. It is very easy to overwrite data accidentally in Access. If by embedding your form to the Navigation form you mean that your form is now a "subform" of the Navigation form, then you'll have to adjust the syntax you use to reference the combobox. You may have to register before you can post: click the register link above to proceed. However, as you can see from the design-view image of the form below, there aren't any subforms embedded on these tab-pages. [Enter] key within Access, you can move from control to control on a form or to a subform. BrowseTo operates similarly but is much more flexible. Access Subform functionality in Visual Basic Form If this is your first visit, be sure to check out the FAQ by clicking the link above. In a Microsoft Access form with a linked subform, when the master record is updated, the subform resets itself to the first record. To add a subform to a main form, go into design view of the main form; Drag a form to be used as a subform from the Navigation Pane. 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, but only using on subform container in order to speed up form loading. The Filter property of forms (introduced in Access 95) makes it easy to filter a form based on a control in the form. Forms in Access can be embedded into other forms, creating a main form and subforms. Form Name: Main NavigationControl Name: NavigationControl Navigation Button I want to be the current and selected: nvbDataCenter. 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. This property refers to a form object. I want subform2 to be related/influenced by subform1; so that a record shown/selected in subform1 results in the related records in subform2 to be shown. Below is a step-by-step guide to creating a form and subform from a table. Sample Database: LinkingTwoSubforms. The subform control is a container for the fsub_CustomerBalance form. How do you do that?. Continuous Forms Subform Control Turn off Navigation Buttons 5. Embed a subform control Learn how to use Access forms and reports to control and organize the display of your data, as well as gather parameters for queries. When using code to refer to the subform, you use the subform. Sub-Forms Subforms are the best and most useful feature of MS Access. Microsoft Access 2016 - Level 2 & 3 / Advanced. You may have to register before you can post: click the register link above to proceed. I am ok with designing the forms around a common resoultion. Is it an Access Subform. ICT Training, Maxwell School of Syracuse University Page 5 Create a form by using the Form Wizard To be more selective about what fields appear on your form, you can use the Form Wizard instead of the various form-building tools previously mentioned. When referencing a subform on a navigation form it must be like so: Take note that it is a ". Close command closes both forms. I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. The NavigationControl object contains a collection of navigation buttons, each of which is represented by a NavigationButton object. Unloading the subform on a parent form's Current event would be too late because the navigation would force the linked subform to re-filter. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. I'm working on correcting an issue in an Access 2007 database I inherited. ) Your database objects appear. MS Access Tab Control with Multiple Subforms. Modifying and Working with Subforms MS Access tutorial. Access 2016 provides several layouts for Navigation forms; which one you choose depends on what you need done. After the 2nd submit button is used I'd like the reciever of the form to have access to the disabled subform. Objects haveproperties and methods within Access. I'd prefer to have a button in the main form that would do all the work. To continue with your YouTube experience, please fill out the form below. that way refer to the exactly point in form, not flexible like "me. Under each navigation button, there are three main functions under the Data tab of Property Sheet: Navigation Target Name, Navigation Where Clause, and Enabled. Both A and B are in datasheet view.