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