Open the main form in design view. Select the subform control. Open
properties and go to the Data tab. Set the Linkmaster and Linkchild
properties to MemberID. The subform will now only show the data in the
subform for the member in the main form.

If you want help with yur database, I can help. I provide help with Access,
Excel and Word applications for a very modest fee. I can get your database
up and running quickly for a very reasonable fee. Contact me to begin using
your database soon.

Steve



"JD Steiger" JD wrote in message
...
I am trying to create a membership database for a church.

I need to have all members entered into the database, then for the members
I
need to have their spouse name and anniversary, and the names of their
children. I am trying to get a subform for each of these into the main
form,
but when I try to use it it just shows the spouse in the first spot as the
spouse for every record.
I need to lock or bind this information to each "Master" form.
So that joe smith at 123 anyplace somewhere usa will show his spouse and
children while joe smith at 456 somewhere anyplace usa will show his
spouse
and children also the spouse's page (jane smith) will show joe smith as
her
spouse with their children.
I would also like to hyperlink the spouse name so that if you click it
their
record will be pulled up.

Anyone that can help me with this endeavor would be greatly appreaciated.