Grouping a form

[UT227]

I have a form that lists employees and classes they've taken. On each record, the employee is listed along with the information on a continuous form. I want it to list the employee once and the records for that employee under the name. I would like to have each employee shown on the form continuously like that. I know that reports have a grouping that will do that. Will a form do the same thing?

[Micron]

Pretty sure there is no such thing still. You can group controls on a form, but that's layout related, not data related. The closest thing to what you ask is a main form (the one side of the relationship) that shows the main entity. A subform (for the many side) shows all records related to the main entity and is usually placed below the main form header. If the main form has multiple records for the entity (a list would be another way of describing it) then you can navigate from one main entity to another, usually by using the built in navigation controls. For each new entity that's shown in the main form, the related records are shown in the subform.

Since forms are really meant for manipulating records, there ought to be no need for grouping by an entity since editing/appending the many side of the relationship would be problematic. If all you want to do is view the data in a grouped fashion, then use a report since that's what it's designed for.

[pbaldy]

There is no such option on reports that I'm aware of. I've achieved a similar look by basing the form on a union query that pulled together the data in the desired format. That of course makes it read-only, so you have to jump through hoops to update data on the form.

[UT227]

That's what I was guessing. Thanks.