Access 2007 Clickable Header to show Summary Data on Form

[mjwillyone]

I have three tables in Access 2007. The first is the donor contact information. The next two tables are linked by the the GiftRef (gift reference) field. The first table (G03GHDR) shows the main information (gift header) of donations given to our organization, one field being the entire value of the donation The next table (G04GDL)shows the detail of the gift (i.e. how much of the check goes to project a, how much to project b, etc.)



I was able to create a form that shows the donor info at the top, and a sub-form of the gift header at the bottom.

I am trying to find a way so that when the gift header is clicked (maybe a plus sign next to it), the gift detail opens up below it. Honestly, I am good at searching this forum for help, but I don't even know what to call this.

Can someone help?

Thank you very much!
Mike

[ranman256]

this would be a Sub form.
put the subform in the form, make it invisible.
when user clicks the header:

subDetail.visible = true

[ssanfu]

I would have a query based on table "G03GHDR" in the main form detail section.
In the footer would be a subform based on a query (based on table "G04GDL"). Link the main form/ sub form on the PK/FK fields
Is "GiftRef" a number field?


Would you post your dB? Only need a few records for testing. Change any sensitive data.....