A form with headers like a report (continuous forms within continuousforms?)

  • Thread starter Thread starter Patrick B
  • Start date Start date
P

Patrick B

I'm building a medical database. I want a form that allows users to
check off diagnoses. The diagnoses need to be split up into categories.
This is totally do-able on reports: just have a group header for
Category. But I can't figure out how to simulate the same effect on a form.

The end result should look like this:

CategoryName1
[ ] Option 1
[ ] Option 2
CategoryName2
[ ] Option 3
[ ] Option 4

(Those are meant to be checkboxes.)

The way I'd like to solve the problem is to have a continuous form of
Categories, and in the detail section have the category name and right
below it a subform. The subform would be a continuous form of related
Diagnoses.

But Access won't let you put a continuous form as a subform within
another continuous form.

I sense the solution may involve some special coding. Any body have any
ideas?

Thanks much!

-Patrick
 
You're correct; Access forms do not permit a continuous subform within a
continuous form.
Here's one solution I've seen, which may or may not fit your needs:
Put your subform in the footer of the form. (The header also works, if that
apppeals to you.)
Set the LinkMasterFields and LinkChildFields so that the subform always
shows the relevant details for the record selected in the main form.
Admittedly, this won't get you all the details at the same time, but it
will give you a convenient way to step through them all.

HTH
 
Thanks MaxDermott. That's not a bad idea. I've taken that idea and
developed something that may work. But I'm going to look around a bit
more and see if I can't find a solution that's closer to what I had
originally envisioned.
You're correct; Access forms do not permit a continuous subform within a
continuous form.
Here's one solution I've seen, which may or may not fit your needs:
Put your subform in the footer of the form. (The header also works, if that
apppeals to you.)
Set the LinkMasterFields and LinkChildFields so that the subform always
shows the relevant details for the record selected in the main form.
Admittedly, this won't get you all the details at the same time, but it
will give you a convenient way to step through them all.

HTH

I'm building a medical database. I want a form that allows users to
check off diagnoses. The diagnoses need to be split up into categories.
This is totally do-able on reports: just have a group header for
Category. But I can't figure out how to simulate the same effect on a
form.

The end result should look like this:

CategoryName1
[ ] Option 1
[ ] Option 2
CategoryName2
[ ] Option 3
[ ] Option 4

(Those are meant to be checkboxes.)

The way I'd like to solve the problem is to have a continuous form of
Categories, and in the detail section have the category name and right
below it a subform. The subform would be a continuous form of related
Diagnoses.

But Access won't let you put a continuous form as a subform within
another continuous form.

I sense the solution may involve some special coding. Any body have any
ideas?

Thanks much!

-Patrick
Click to expand...
Click to expand...
 
Back
Top