Grouping on a form... possible?

[Aaron G]

Hi all,

Using A2003 - I would like to be able to group data on a form. I understand
I can create subforms, but I would have an unknown number of groups to create
the forms for. What would be the best approach? Basically, I would like to
be able to group like you can in reports.

Here's an example:

Let's say I want to group Widgets and their Price by the group heading of
Materials used to create the widget;

Wood
Widget 1 - 10
Widget 2 - 12
Metal
Widget 1 - 18
Widget 3 - 28

Any ideas?

TIA

Aaron G
Philadelphia, PA

 

[Larry G.]

Do you want to do this in a report or a form?

 

[Aaron G]

Form. I can do it just fine on a report and would like the same
functionality on a form.

Aaron G
Philadelphia, PA