Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft database training - Automatic Form/Table creation
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft database training - Automatic Form/Table creation
Resolved · Low Priority · Version Standard
ReplyAutomatic Form/Table creation
Why does Access add a table to my form when I use the AutoForm option?
For upcoming training course dates see: Pricing & availability
RE: Automatic Form/Table creation
Answer to the question:
Access will analyse the table before an AutoForm is created, if there are relationships in place; where your table is the 'one' side of a 'one to many' relationship, then Access will include the secondary table as a sub-form, this will enable you to view the main table records 'one side' and also scroll through any of the 'many side' records on the sub-form.
If you wish to create a Form from your secondary table and use that rather than the default secondary table, you must insert the sub-form manually in the main Form's design view.
Sub-Forms are covered in detail on the Access Advanced course.
|