Grouping on a Form/Subform 1

[JOEYB99]

I am currently using Access 2007 and have a situation where I would like to produce a continuous form/subform that performs a groupings' effect similar when creating reports.

I have a table which is made up of observed activities, each with their own unique reference number expressed as decimal numbers. Activities 1.1, 1.2 and 1.3 all belong to the same category, class 1. This table has the fields observed_activity_ref_number(PK), activity_description, category_class, active_status.

I have another table of categories with the fields category_class(PK), category_description, and active_status.

So this is a one-to-many situation. A category can have one or more observed activities and an observed activity can only be associated with one category.

I would like the input form to show all observed activities and also show a category grouping capability so I could have the category name/description on the form only once, for each grouping of observed activities.

For example,
category description for 1
observed activity 1.1
observed activity 1.2
observed activity 1.3

category description for 2
observed activity 2.1
observed activity 2.2

Any help would be greatly appreciated.

 

[MajP]

As you point out this can be done in a report, but no real way to do this on a form. You could do some different effects. You could have two continuous subforms one with categories and the other with linked activities. So you could click on any category and the other subform would show the related activities. Or you could concatenate the activities into a single field and have a single continuous form. Or you could use a listbox and populate it through code. Or use a treeview which takes a bit more coding.