Forum home » Delegate support and help forum » Microsoft Access Training and help » Subform Access 2003
|
|
|
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. |
Subform Access 2003
Resolved · Low Priority · Version 2003
Reply Mon 14 Jul 2008, 15:09Delegate Lu said...
Lu has attended:
Access Intermediate course
Excel VBA Intro Intermediate course
Subform Access 2003
What's the benefit of using subform? When entrying data, what is the difference between a subform and creating a form using fields from different tables/queries?
Thanks.
Lu
For upcoming training course dates see: Pricing & availability
RE: Subform Access 2003
Hi Lu,
Thank you for your post, welcome to the forum, in answer to your question, there are many reasons and benefits to using subforms.
As the form is the usual place where input and editing of records takes place as it is user friendly, then by using a sub form, which is normally the many side of a one to many relationship, the main form being the one side, the user can view both the main record and all linked records ie a form showing departments will have a sub form showing employees in that department. If the forms were created by using fields from different tables or queries there is the change that fields which are not included in the query would not be completed/edited. If however you are creating a query which hold all the fields from multiple tables and/or queries you could quite easily introduce errors.
Access is designed as a multi-relational program.
I hope that has answered your question, if so please click the resolved link, regards Pete
|