Forms

Dear Lakshmi

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

If you have set up the relationships between tables then you can create a subform within a form for those tables.

The main purpose of the forms and subforms is that you can view the content of one table while viewing the details of another related table!! The best example for this is that if you have a table called customers and have another table called Orders. you can create two separate forms for each of the tables. Then you can open the Customers Tables and within that have the Orders form as a subform. You can view the customers and their corresponding orders on the same form.

I believe we covered forms and subforms in our Intermediate course. If you are not sure how to create subforms then please let me know and I should be able to guide you.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please either reply to this post or post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007