Using Subforms in Microsoft Access

Subforms in Microsoft Access enable you to view and edit information in one table based on related information in another. For example, you can view the information for a customer on the main form and see a listing of their previous orders in a subform. Subforms are a useful tool in Access that you'll use often and this video shows how to set them up easily.
In this course, I provide a complete overview of designing a database application in Microsoft Access especially for those who are new to the software. The course features over five hours of video and downloadable resources to help you get a quick, easy introduction to managing your data with Access.
You can see the entire playlist at • Managing Your Data wit... .
This course was previously offered on Udemy and through my own online school at comeau-software.... I've now decided to offer it for free. If you enjoy this content, please Like and Subscribe and check out my other resources at ComeauSoftware.com.

[@satyabanukil779]

Sir I have a simple query. I have only one table. There are numerous fields. Since a single table database, building relationship does not arise. But considering number of fields in the table. I want to split the fields in one form and one subform. Now I want to link two forms. In the main form if I change or enter new data, the subform shall display data corresponding to the field appears in both the forms. Shall be grateful if any advice is given. Regards

[@ComeauSoftwareSolutions]

Subforms are meant to support one-to-many relationships between tables. There would be no purpose to using a subform this way. I would recommend looking at the tab control in the form designer. You can put a series of tabbed pages on a form and split the fields up that way.