When should I opt to use a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What are they really for?

Why not use one long form with different sections?

What is the advantage of using a sub form?
 
andreainpanama said:
What are they really for?

Why not use one long form with different sections?

What is the advantage of using a sub form?
Click to expand...

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.
 
Back
Top