Grouping data on a form

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I’m trying to create a form that is grouped by individual names with the data
pertaining to that name listed below it. I know this can be done on a report
but, I just can figure out how to do this on a form.

Example;
Name 1
Med1 Generic1 Dose 1
Med2 Generic2 Dose 2

Name 2
Med 1 Generic1 Dose 1
Med 2 Generic2 Dose 2

Name 3
Med 1 Generic1 Dose 1
Med 2 Generic2 Dose 2
 
On Thu, 1 Oct 2009 16:34:22 -0700, Harold

Perhaps you can create a subform with names, and a subsubform with
Meds. Both would be in datasheet view.

-Tom.
Microsoft Access MVP
 
Thanks Tom,
I could make it work but, it is not really what im looking for. I will have
to play with it a little more but, I would like to do it as a continuous
form.
 
On Fri, 2 Oct 2009 00:03:01 -0700, Harold

Sorry, continuous forms cannot have subforms. I am assuming someone
could have many meds.

-Tom.
Microsoft Access MVP
 
Yes one person could have anywhere from one to a hundred meds. I was hoping
to not have any sub forms and group by names on the form. In the same way
you can do grouping on a report.
 
Yes one person could have anywhere from one to a hundred meds. I was hoping
to not have any sub forms and group by names on the form. In the same way
you can do grouping on a report.
Click to expand...

As far as I know, you cannot. You *certainly* could not do so and have the
data updateable, except by drastic denormalization.
 
Back
Top