Continuous Subform won't display Page Header.

[Mimadocken]

I'm working in Access 2007, building a small database for a volunteer organization. Some of our people are "coordinators" for outside groups. Some volunteers share coordinator duties for one large outside group.

I'm trying to build show which volunteers coordinate with which outside groups. I've built 3 tables and a query.

tblVolunteers
VolID - autonumber & PrimeKey
VolFirstName - txt
VolLastName - txt

tblOutGroups
OGID - autonumber & PrimeKey
OGName - txt

tblCoordinate
CoordID - autonumber
VolID - long integer, no dupes, SharedKey
OGID - long integer, no dupes, SharedKey

qryVolOut
tblCoordinate
tblVolunteers
tblOutGroups
VolID from tblCoordinate
OGID from tblCoordinate
OGName from tblOutGroups
CoordID from tblCoordinate

I had thought the following should work, but I'm having problems.

On the Volunteer Form, I placed a Continuous Subform bound to the query called qryVolOut. The Master/Child field is VolID. I added a combo box to the Page Header of this Subform that gets its data from tblOutGroups. It hides the OGID and displays the OGName. It is supposed to write OGID into the OGID field of the subform, which in turn will display a list of Groups for whom this volunteer is coordinator. When I do a report later, I should also see multiple people shown as coordinators at an Outside Group if that is correct.

Now to the problem. For some reason, my subform is not displaying the page header, so I can't see the combo box and select the Groups. Can anyone tell me what I'm doing wrong? :banghead:

Thank you for your help.

 

[shizekopf]

use a Form Header instead of Page Header