Access Forms

Dear Rosie

Thank you for attending Access Courses. I hope you enjoyed the courses and benefited from them.

Before you create the subform please ensure that the relationship between the tables has been established.

Although when you are creating a subform you can choose existing tabels or query to be displayed as subform but it looks better if the subform was being extratcted from an existing form.

I hope you are aware that when you create relationships teher is a primatry table and a secondary table. e.g. Customers and Orders. Customers will be the primary table and the orders will be the secondary table because One Customer can Place many orders.

Once you have established the relationship then create seperate forms for each tables.

Open the Primary form (Customer in our case).

On the Toolbox Press the SubForm/Subreport button and drag that to the main Form. In the Wizard choose the Forms options and select the secondary form (Orders in our case).

This should provide you with the details of each customer on the main form and their placed orders in the subform.

I hope this helps. If this has helped in answering your query then please mark this post as resolved.


Many thanks

Kindest Regards

Rajeev Rawat

MOS Master Instructor 2000/2003
MCAS Master Instructor 2007