Forms - Grouping?

  • Thread starter Thread starter Jason Gyetko
  • Start date Start date
J

Jason Gyetko

Is there no grouping option within a form like there is in a report? If
not, is it possible to attach a report as a sub to a form, this way I can
use the grouping capality from the report on my form. Or can you have drop
down menus on a report? How do you group on a form? Any input would be
greatly appreciated. Thanks.
 
If the grouping you are after is grouping detail records
from the many side of a one-to-many relationship to the
one side, create a tabular subform for the detail records,
and drag it to your main form while in design view.
Update the Link Child Fields and Link Master Fields
properties to indicate the linking key field in the
subform and main form's record sources, respectively.

For example, this could display all the orders from a
given customer:

CustomerID: 10101
CustomerName: Bob's Sausage
Address:
....
Etc.

Orders Subform

Order# Date Total
======= ====== ========
1234 1/2/03 $345.00
4234 2/2/03 $365.00
6123 9/2/03 $876.00

HTH
Kevin Sprinkel
 
Is there no grouping option within a form like there is in a report?
Click to expand...

There is not.
If not, is it possible to attach a report as a sub to a form, this way I can
use the grouping capality from the report on my form. Or can you have drop
down menus on a report? How do you group on a form? Any input would be
greatly appreciated. Thanks.
Click to expand...

Could you explain what you are trying to accomplish, with an example
of the nature of your data and what you want to see?
 
Back
Top