Need a SubForm that displays existing data

[Fred Worthington]

Greetings:

Unlike the typical SubForm, into which data is entered after a new record is
created in the Main Form, I need a SubForm that will retrieve and display
data that has already been recorded.

Here's the scenario: I need to track the activities of Volunteer Workers
who perform services for various Church Organizations. The Main Form
contains personal and contact information for the Volunteer. I need a
Subform that displays information previously recorded in one of several
ChurchGroup Tables (i.e., Pastor, Address, Phone, etc.) relevant to the
Church Organizations for which the Volunteer performs services. The Groups
are Baptist, Methodist, Presbyterian, etc. Each Group contains a number of
Organizations. Therefore, the two fields that distinguish a particular
Church Organization from all others are the ChurchGroup Field and
ChurchOrganization Field in each of the Group Tables. How can I provide a
way for the data entry person to select a specific Organization and display
its relevant Fields of data in a SubForm that is linked to the Volunteer?

I envision a Field (i.e., a Combo Box) that provides a drop-down list of
Church Groups. When the Group is selected it would automatically display a
list of the associated Church Organizations from that Group which, when
selected, would in turn display a Form (or Window) with that Organization's
information. Can anyone point me in the right direction on this?

Thanks . . . Fred