{"id":67117,"date":"2025-08-15T07:42:06","date_gmt":"2025-08-15T07:42:06","guid":{"rendered":"https:\/\/www.accessrepairnrecovery.com\/blog\/?p=67117"},"modified":"2025-08-17T19:33:57","modified_gmt":"2025-08-17T19:33:57","slug":"create-split-form-in-ms-access","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access","title":{"rendered":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In MS Access, split forms are beneficial and even perilous too. But sometimes, they refuse to work when you put them inside the navigation form. In such instances, you must create a split form in Access using the Split Form Tool or VBA (Visual Basic for Applications) to make it work again. So, here is the user-friendly tutorial for you on <strong>how to create a split form in Access database<\/strong>.<!--more--><\/p>\n<p>So, let\u2019s start with the post\u2026<\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h4><strong>Quick Navigation:<\/strong><\/h4>\n<ul>\n<li style=\"text-align: left;\"><strong><a href=\"#part1\">What Is a Split Form In Access?<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#part2\">How To Create a Split Form in Access with Split Form Tool?<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#part3\">How To Make A Split Form In Access Using VBA Code?<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong><a href=\"#part4\">Try The Recommended Way To Repair Corrupted MS Access File<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#part5\">Frequently Asked Questions<\/a><\/strong><\/li>\n<\/ul>\n<p><a name=\"part1\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>What Is a Split Form In Access?<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>A split form<\/strong> is a form in the MS Access that allows displaying the same datasheet or record in two views at the same time. Even though two views are associated with the same information source &amp; are synchronized with each other.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67124 size-full\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Split-feature.png\" alt=\"Create A Split Form In Access\" width=\"666\" height=\"381\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Split-feature.png 666w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Split-feature-300x172.png 300w\" sizes=\"auto, (max-width: 666px) 100vw, 666px\" \/><\/p>\n<p style=\"text-align: justify;\">However, if you select a field on one side of a form, then it selects the same field in another part of the form. It means that whatever changes you make on one side of your split form, the same changes will apply to the other side of the form.<\/p>\n<h3 style=\"text-align: left;\"><strong>When to Use a Split Form in Access?<\/strong><\/h3>\n<p style=\"text-align: justify;\">Split forms are ideal when you need to view and edit records simultaneously. They work well in situations like:<\/p>\n<ol>\n<li style=\"text-align: left;\">Managing the customer information.<\/li>\n<li style=\"text-align: left;\">Recording student\/employee data.<\/li>\n<li style=\"text-align: left;\">Tracking sales &amp; inventory.<\/li>\n<li style=\"text-align: left;\">Reviewing large datasets quickly.<\/li>\n<\/ol>\n<p><a name=\"part2\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>How To Create a Split Form in Access with the Split Form Tool?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Creating a split form in the Access is a much easier task than you think it is. Nevertheless, it can be only possible when you have the right solution with you. Undoubtedly, with the help of Split Form Tool it is possible.<\/p>\n<p style=\"text-align: justify;\">Here is the step-by-step guide on <strong>how to make a split form in Access using Split Form Tool<\/strong>. Let\u2019s try them:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Under a <strong>Navigation Pane<\/strong>, you have to click on query or table that holds the data you need on your form.<\/li>\n<li>At this time, on a\u00a0<strong>Create\u00a0<\/strong>tab, under\u00a0<strong>Forms <\/strong>group, you have to click on the\u00a0<strong>More Forms<\/strong>.<\/li>\n<li>Now, click on the\u00a0<strong>Split Form<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67125\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-1.png\" alt=\"how to make a split form in Access\" width=\"614\" height=\"389\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-1.png 614w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-1-300x190.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p style=\"text-align: justify;\">Nevertheless, a default split form will launch as displayed below. Though, you can easily modify the settings in a form property.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67126\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/default-split-form-840x362-1.png\" alt=\"how to make a split form in Access\" width=\"729\" height=\"314\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/default-split-form-840x362-1.png 840w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/default-split-form-840x362-1-300x129.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/default-split-form-840x362-1-768x331.png 768w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>How To Set Form Separator In A Certain Position?<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Step 1:<\/strong> Switch to the\u00a0<strong>Design view<\/strong>\u00a0simply by right-clicking on a form under <strong>Navigation Pane &gt;&gt; <\/strong>click on\u00a0<strong>Design View<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 2:<\/strong> In case, a property sheet isn\u2019t displayed, then press\u00a0<strong>F4<\/strong>\u00a0key to show it.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 3:<\/strong> Here, you can simply change the\u00a0<strong>Height<\/strong>\u00a0of a Form Header as per your requirement. (For example, set to 1\u201d)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67127\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/form-header.png\" alt=\"how to make a split form in Access\" width=\"659\" height=\"269\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/form-header.png 781w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/form-header-300x123.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/form-header-768x314.png 768w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Step 4:<\/strong> Under Property Sheet Format tab, you have to change the below things:<\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Navigation Buttons<\/strong>\u00a0to:\u00a0<strong>No<\/strong><\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Scroll Bars<\/strong>\u00a0to:\u00a0<strong>Neither<\/strong><\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Dividing Lines<\/strong>\u00a0to:\u00a0<strong>No<\/strong><\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Save Splitter Bar Position<\/strong>\u00a0to: <strong>Yes<\/strong><\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Split Form Splitter Bar<\/strong>\u00a0to:\u00a0<strong>No<\/strong><\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Split Form Size<\/strong>\u00a0to:\u00a0<strong>1\u201d<\/strong>\u00a0(For example- \u201c1\u201d)<\/p>\n<p style=\"text-align: justify;\">\u2013 Change <strong>Border Style<\/strong>\u00a0to:\u00a0<strong>None<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67129\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/updated-property.png\" alt=\"Create A Split Form In Access\" width=\"682\" height=\"487\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/updated-property.png 741w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/updated-property-300x214.png 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Form View<\/strong><\/p>\n<p style=\"text-align: justify;\">Now, from property settings which you can see above, the form sight will show like a below picture.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67130\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2.png\" alt=\"Create A Split Form In Access\" width=\"748\" height=\"358\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2.png 840w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-300x144.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-768x368.png 768w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-calculated-field-in-access\" target=\"_blank\" rel=\"noopener\">How To Create Calculated Field In Access?<\/a><\/strong><\/p>\n<\/blockquote>\n<h3 style=\"text-align: left;\"><strong>How To Turn the Existing Form into The Split Form?<\/strong><\/h3>\n<p style=\"text-align: justify;\">Well, you can switch your current form into the split form simply by setting some of the properties in a form.<\/p>\n<ul style=\"text-align: justify;\">\n<li>First of all, you have to open a form in the Layout view simply by right-tapping it in the Navigation Pane &amp; then click on <strong>Layout View<\/strong>.<\/li>\n<li>In case a property sheet isn\u2019t displayed, you have to press <strong>F4<\/strong> key to show it.<\/li>\n<li>Choose the\u00a0<strong>Form <\/strong>from a dropdown list, which you can see at the upper side of a property sheet.<\/li>\n<li>Now, on a\u00a0<strong>Format <\/strong>tab, in a\u00a0<strong>Default View <\/strong>dropdown list, you have to choose the <strong>Split Form<\/strong>.<\/li>\n<li>Finally, save &amp; close a form, &amp; make double-click on a form in the Navigation Pane in order to open it in the Form view.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>How to Hide or Unhide The Fields On A Split Form?<\/strong><\/h3>\n<p style=\"text-align: justify;\">You can even use\u00a0<strong>UnhideColumns<\/strong> commands to hide\/unhide the field on a datasheet of your Split Form. Here are the easy steps on how you can do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li>First, Add the button<\/li>\n<li>Choose\u00a0<strong>[Embedded Macro] <\/strong>option on a Property Sheet or <strong>On Click Event<\/strong>.<\/li>\n<li>Then, add\u00a0the <strong>RunMenuCommand\u00a0<\/strong>in a Macro Window<\/li>\n<li>Now, add\u00a0the <strong>UnhideColumns <\/strong>in a RunMenuCommand<\/li>\n<li>Finally, you have to<strong> Save &amp; Close <\/strong>a Macro window.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67131\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1.png\" alt=\"Create A Split Form In Access\" width=\"802\" height=\"294\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1.png 840w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1-300x110.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1-768x282.png 768w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/p>\n<p style=\"text-align: justify;\">When you\u00a0<strong>uncheck\u00a0<\/strong>the checkbox in front of a column name, your field (column) will be wiped out from a datasheet view.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67132\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Hide-fields-840x335-1.png\" alt=\"Create A Split Form In Access\" width=\"840\" height=\"335\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Hide-fields-840x335-1.png 840w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Hide-fields-840x335-1-300x120.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/Hide-fields-840x335-1-768x306.png 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p><a name=\"part3\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>How To Make A Split Form In Access with VBA Code?<\/strong><\/h2>\n<p style=\"text-align: justify;\">VBA code is another option that can help you to create a split form in Access. Here&#8217;s how you can do so:<\/p>\n<h3 style=\"text-align: left;\"><strong>Step 1: Open a split form &amp; update a Default View.<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67133\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-2.png\" alt=\"Open a split form &amp; update a Default View\" width=\"932\" height=\"233\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-2.png 932w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-2-300x75.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/1-2-768x192.png 768w\" sizes=\"auto, (max-width: 932px) 100vw, 932px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Simply open a split form.<\/li>\n<li>Though in the design view, choose the <strong>Form<\/strong>.<\/li>\n<li>After this, go to a Property Sheet or you can ALT + Enter keys together &gt; <strong>Form<\/strong><\/li>\n<li>Now, change a default view to the Single Form.<\/li>\n<li>Finally, close a form &amp; save the changes.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>Step 2: Make a new copy of your form.<\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Initially, go to a <strong>Navigation Pane<\/strong>.<\/li>\n<li>Make right tap on the form &amp; choose <strong>Copy<\/strong>.<\/li>\n<li>At this time, right-tap on the blank area under a navigation pane &amp; choose <strong>Paste<\/strong>.<\/li>\n<li>Now, rename the Form. Add it with the <strong>\u201c_Datasheet<\/strong>\u201d.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>As for Example:<\/strong><\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>Copy of a Form:- Members_Datasheet<\/li>\n<li>Form:- Members<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>Step 3: Open a Datasheet Form &amp; update its view properties.<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>Just open a <strong>Datasheet form<\/strong>.<\/li>\n<li>In the design view, you have to choose the <strong>Form<\/strong>.<\/li>\n<li>After that, go to a <strong>Property Sheet<\/strong> then <strong>Form<\/strong><\/li>\n<li>Now, update the below properties:\n<ul>\n<li><strong><em>Allow the Datasheet View <\/em><\/strong><em>to<strong>: <\/strong><\/em>Yes<\/li>\n<li><strong><em>Default View <\/em><\/strong><em>to<strong>: <\/strong><\/em>Datasheet<\/li>\n<li><strong><em>Allow the Form View <\/em><\/strong><em>to<strong>: <\/strong><\/em>No<\/li>\n<\/ul>\n<\/li>\n<li>Finally, close a form &amp; save.<\/li>\n<\/ol>\n<h3 style=\"text-align: left;\"><strong>Step 4: Re-open a Main Form &amp; add Datasheet Form simply as the Subform.<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>Simply open main form (<strong>which was copied<\/strong>) under the design view.<\/li>\n<li>Then, Add the subform.<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li>First, go to the Design menu &gt;&gt; then select the <strong>Subform\/Subreport<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67134\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1-1.png\" alt=\"default view then split form option in Access\" width=\"654\" height=\"220\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1-1.png 654w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/2-1-1-300x101.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Tap on a Detail area.<\/li>\n<li>Now, a SubForm Wizard seems.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67135\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/3-1.png\" alt=\"Create A Split Form In Access\" width=\"498\" height=\"372\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/3-1.png 498w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/3-1-300x224.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/3-1-320x240.png 320w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Here, click on the \u2018<strong>Use the existing form\u2019<\/strong> &gt;&gt; choose your data sheet form and then click on <strong>Next<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-67136\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/4-1.png\" alt=\"Create A Split Form In Access\" width=\"506\" height=\"376\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/4-1.png 506w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/4-1-300x223.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose \u2018<strong>Define my own\u2019<\/strong> &gt;&gt; tap on <strong>Finish<\/strong><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Now, the data sheet form is a subform. Change it to your favourite position and size.<\/li>\n<\/ol>\n<h3 style=\"text-align: left;\"><strong>Step 5: Lastly, add a code.<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>First, open a VBA Editor or you can press the (<strong>ALT+F11<\/strong>).<\/li>\n<li>Choose a main form &amp; paste the below code:<\/li>\n<\/ol>\n<pre>'MAIN FORM\r\nOption Explicit\r\n\r\nPrivate Sub Form_AfterUpdate()\r\n\u00a0\u00a0 Me.Members_Datasheet.Requery\r\nEnd Sub\r\n\r\nPrivate Sub Form_Current()\r\n\u00a0\u00a0 If Me.NewRecord Then\r\n\u00a0\u00a0\u00a0\u00a0 Me.Members_Datasheet.Form.Recordset.AddNew\r\n\u00a0\u00a0 Else\r\n\u00a0\u00a0\u00a0\u00a0 Me.Members_Datasheet.Requery\r\n\u00a0\u00a0 End If\r\nEnd Sub<\/pre>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Once you have copied the code, then replace the term <strong>Members_Datasheet\u00a0<\/strong>by a real name of a datasheet form.<\/li>\n<li>After finishing that, choose the <strong>Datasheet Form<\/strong> via a Project menu &amp; copy the below code:<\/li>\n<\/ol>\n<pre>'SUBFORM\/DATASHEET FORM\r\nOption Explicit\r\n\r\nPrivate Sub Form_AfterUpdate()\r\n\u00a0\u00a0 Me.Parent.Form.Requery\r\nEnd Sub\r\n\r\nPrivate Sub Form_Current()\r\n\r\n  Dim pk_field As String, pk_tbox As Control\r\n\u00a0 Dim primaryKey As String, strSearch As String\r\n \r\n\u00a0 Set pk_tbox = Me.Member_ID 'textbox containing primary key *\r\n\u00a0 pk_field = \"Member_ID\" 'primary key field name *\r\n\r\n\u00a0 primaryKey = Nz(pk_tbox.Value, 0) 'change value to 0 if null\r\n\u00a0 pk_field = \"[\" &amp; pk_field &amp; \"]\" 'enclose field name with brackets\r\n \r\n\u00a0 If primaryKey &lt;&gt; 0 Then 'if not null (or not a new record)\r\n\u00a0\u00a0\u00a0 strSearch = pk_field &amp; \"=\" &amp; primaryKey\r\n\u00a0\u00a0\u00a0 Me.Parent.Recordset.FindFirst strSearch\r\n\u00a0 Else\r\n\u00a0\u00a0\u00a0\u00a0 Me.Parent.Form.Recordset.AddNew\r\n\u00a0 End If\r\n\r\nEnd Sub<\/pre>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li>Now, update values for below term:<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li><strong>pk_tbox<\/strong>\u2013 states to a text box holding a primary key option.<\/li>\n<li><strong>pk_field<\/strong>\u2013 states to a record of the primary key source.<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"6\">\n<li>Once done, you have to save all the changes by pressing (<strong>CTRL+S<\/strong>) &amp; closing the VBA Editor.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">That\u2019s it!<\/p>\n<h2 style=\"text-align: left;\"><strong>Tips for Working with Split Forms<\/strong><\/h2>\n<ol>\n<li>Use the <strong>Property Sheet<\/strong> in the database to modify design settings.<\/li>\n<li>It is important to add conditional formatting for clearer data presentation.<\/li>\n<li>Apply filters in datasheet view for quick record searches.<\/li>\n<li>Lock specific fields to prevent editing errors.<\/li>\n<\/ol>\n<p>These small adjustments enhance the efficiency of your split form in Microsoft Access.<\/p>\n<p><a name=\"part4\"><\/a><\/p>\n<h2 style=\"text-align: justify;\"><strong>Try The Recommended Way To Repair a Corrupted MS Access File<\/strong><\/h2>\n<p style=\"text-align: justify;\">When it comes to <strong>repairing corrupted MS Access files,<\/strong> there is nothing better than the <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool\" target=\"_blank\" rel=\"noopener\">Access Database Repair Tool<\/a>.\u00a0<\/strong>It is a progressive solution for all Microsoft Access Database errors or issues.<\/p>\n<p style=\"text-align: justify;\">Besides, this feature-loaded program can repair each and every data, such as <strong>reports, tables, forms, queries, macros<\/strong>, etc.<\/p>\n<p style=\"text-align: justify;\">The best thing about this tool is that it has a powerful algorithm that thoroughly scans the severely <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/repair-and-restore-partial-corrupted-mdb-access-file\" target=\"_blank\" rel=\"noopener\">corrupted\/damaged .mdb<\/a> &amp; .accdb<\/strong> files and then fixes them.<\/p>\n<p style=\"text-align: justify;\">So, without any delay, just download and install this software on your PC and follow the steps below to know how it works.<\/p>\n<center><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/06\/en-dwn-btn.jpg' \/><\/a><p style='font-size:11px;'><font color='red'><b>*<\/b><\/font> By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/p><\/center>\n<h3 style=\"text-align: left;\"><strong>Steps To Repair Corrupted\/Damaged MS Access Database<\/strong><\/h3>\n\n<a name=\"part5\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>What Is the Use of Split Form in Access?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Generally, a split form is the form in the MS Access that displays the same information or data in two views at the same time.<\/p>\n<h4 style=\"text-align: left;\"><strong>Which View Must Be Used to Convert an Existing Form Into A Split Form?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Layout view must be used to open and convert an existing form into a split form.<\/p>\n<h4 style=\"text-align: left;\"><strong>How Do I Rename a Split in Access?<\/strong><\/h4>\n<p style=\"text-align: justify;\">You can rename a split in the MS Access by trying the workarounds below:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Rename a split on a backend<\/li>\n<li>You can change a split form to a frontend design view<\/li>\n<li>Remove the previous field name &amp; then insert a new field name into the form.<\/li>\n<\/ul>\n<h4 style=\"text-align: left;\"><strong>Why Would We Want to Split Data Into Separate Tables?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Well, splitting the data into multiple associated tables takes less places to update and fewer redundant data. So, it would be beneficial to split the information into separate tables.<\/p>\n<h2 style=\"text-align: left;\"><strong>Final Verdict<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Creating a split form in MS Access <\/strong>is simple and highly effective. It allows users to interact with data in two ways at once. With this tool, database management becomes faster, more accurate, and user-friendly. By customizing the layout and applying the best practices mentioned in this blog, you can build a powerful and professional form tailored to your needs.<\/p>\n<p>I hope you enjoyed reading this post!<\/p>\n<blockquote><p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-split-form-e8eb0efb-2fa6-4315-9d4b-86e79a1fbe1e\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/create-a-split-form-e8eb0efb-2fa6-4315-9d4b-86e79a1fbe1e<\/a><\/li>\n<\/ul>\n<\/blockquote>\n<div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In MS Access, split forms are beneficial and even perilous too. But sometimes, they refuse to work when you put &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Create a Split Form in Access?- [Step-by-Step Tutorial]\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#more-67117\" aria-label=\"Read more about How to Create a Split Form in Access?- [Step-by-Step Tutorial]\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":67118,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1567,1563],"class_list":["post-67117","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-create-a-split-form-from-the-classes-table","tag-how-to-create-a-split-form-in-access","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create a Split Form in Access?- [Step-by-Step Tutorial]<\/title>\n<meta name=\"description\" content=\"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Split Form in Access?- [Step-by-Step Tutorial]\" \/>\n<meta property=\"og:description\" content=\"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-15T07:42:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-17T19:33:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"How to Create a Split Form in Access?- [Step-by-Step Tutorial]\",\"datePublished\":\"2025-08-15T07:42:06+00:00\",\"dateModified\":\"2025-08-17T19:33:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\"},\"wordCount\":1656,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png\",\"keywords\":[\"create a split form from the classes table\",\"how to create a split form in access\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\",\"name\":\"How to Create a Split Form in Access?- [Step-by-Step Tutorial]\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png\",\"datePublished\":\"2025-08-15T07:42:06+00:00\",\"dateModified\":\"2025-08-17T19:33:57+00:00\",\"description\":\"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png\",\"width\":550,\"height\":310,\"caption\":\"Create A Split Form In Access\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Split Form in Access?- [Step-by-Step Tutorial]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]","description":"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access","og_locale":"en_US","og_type":"article","og_title":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]","og_description":"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2025-08-15T07:42:06+00:00","article_modified_time":"2025-08-17T19:33:57+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]","datePublished":"2025-08-15T07:42:06+00:00","dateModified":"2025-08-17T19:33:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access"},"wordCount":1656,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png","keywords":["create a split form from the classes table","how to create a split form in access"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access","name":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png","datePublished":"2025-08-15T07:42:06+00:00","dateModified":"2025-08-17T19:33:57+00:00","description":"Whether you are a beginner or a pro user, this post will help you to learn how to create a split form in Access for seamless database experience.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2022\/11\/How-To-Create-A-Split-Form-In-Access-1.png","width":550,"height":310,"caption":"Create A Split Form In Access"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/create-split-form-in-ms-access#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create a Split Form in Access?- [Step-by-Step Tutorial]"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/67117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=67117"}],"version-history":[{"count":2,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/67117\/revisions"}],"predecessor-version":[{"id":69120,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/67117\/revisions\/69120"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/67118"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=67117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=67117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=67117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}