Sub forms in Ms Access – A Primer

The Ms Access applicationMSAccessSubform1 is known for its versatile features. When we look at creating forms in Ms Access, not only can we create forms as per our need and design requirements, we can even create sub forms. Basically sub-forms allow you to display an additional form within the parent form structure and can prove to be highly apt when you are looking to display interrelated data. For example if you are looking to create a form to showcase product categories, you may wish to display the products associated with a chosen category. By using sub-forms you can allow your users to drill down through different product categories and discover all products marked under a certain category.


Creating a Sub-form in Ms Access via Wizard

Before you start creating a sub form in Ms Access through the form wizard, you should understand that it works only when tables are related. To start with you should launch the form wizard and select the table. Choose the fields you wish to be placed in the form and follow the onscreen instructions. You would come across a choice where the wizard would ask you to choose the way you wish to view your data. Here you need to check the radio button next to Form with sub-form(s) option. Next you need to choose the layout and choose the style you want in the form. Further you need to name the form and sub-form name and click on Finish to save the design.

It is important to note that Ms Access also allows you to add a sub-form to an existing form. To achieve the same you need first open the form in which you wish to include a sub-form in the design view. Next from the Access tool box choose the Sub-form option and select the location for the sub-form. Follow the onscreen instructions presented by the wizard to complete creating the sub-form.


Do Not Lose your Custom Designed Access Forms to an MDB Crash

In case your Ms Access database crashes, you may fail to locate the custom forms you have created to access the database. An access repair tool like DataNumen Access repair provides you with a hassle free way to get back your data repository along with forms and other structures that you have created. Further when it comes to discovering a missing MDB file, the application is second to none. As opposed to its peers it is capable of recovering the maximum possible data even when the database file has been excessively compromised. It can bring back all the content elements enclosed in the database in quick time and it is not tempered by the location of the MDB file. From relations between tables to fields which contain objects to indexes, everything can be brought back as they were before the crash. Now if you have a whole bunch of MDB files to recover, the batch mode of this powerful tool can complete the recovery process without any difficulty.


Author Introduction:

Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit

Comments are closed.