When should I opt to use a subform?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andreainpanama - 05 Jul 2006 22:55 GMT

What are they really for?

Why not use one long form with different sections?

What is the advantage of using a sub form?

Reply to this Message

Rick Brandt - 05 Jul 2006 23:02 GMT

> What are they really for?
>
> Why not use one long form with different sections?
>
> What is the advantage of using a sub form?

For entering data that is "related" to the data in the main form. Usually
with a one-to-many relationship. Subforms are not about controlling form
real estate (that is what TabControls are for).

Example is a sales order form. One Order (Main form) with many possible
LineItems ordered (subform). The form/subform construct automatically
displays the LineItems in the subform that relate to the order number in the
main form and also automatically populate the linking field(s) data in the
subform when new line items are entered.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message