How can I group on an input form

joe789

Registered User.
Local time
Today, 12:29
Joined
Mar 22, 2001
Messages
154
Hi Folks,

I am trying to group all like records together on a form using a unique person identifier (a person can have more than 1 record); that is, to have each page of the input form focus on the records of only one unique identifier person at a time, then to have some sort of break between each set of a unique person's records. This form will not be used to add any records, only to update them by check marking boxes and what not. Is there any easy way to do this, that is; to force some sort of break on a form between each set of unique person's records? For example, if I had three people: John, Lisa, and Mary. And John had 5 records, Lisa had 2, and Mary had 10 ... is there any way to group all the records for each person in a form used to update the information and to have some sort of eye pleasing visual break between each person's set of records.

Any help would be greatly appreciated,

Thank you,

Joe
 
Create a Continuous Form. Under the proerties of the Form change Default view to Continuous Forms.

From Access Help files:

Set the opening view of a form (one record, more than one, or datasheet)
Open the form in Design view.

Double-click the form selector to open the form's property sheet.

In the DefaultView property box, click one of the following settings.

Setting Description
Single Form Displays one complete record at a time. (Form view only)

Continuous Forms Displays as many complete records as will fit in the detail section of the form. (Form view only)

Datasheet Displays records arranged as rows and columns. Records may scroll off the screen.
 

Users who are viewing this thread

Back
Top Bottom