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.

[satyabanukil]

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