I'm a bit confused by your data structure. But first, some advice regarding
the use of Date as the name of fields and controls. It and many other words
are reserved words in ACCESS, and can create serious confusion for ACCESS
and Jet. See these Knowledge Base articles for more information:
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763
Now, from what you're saying, you have a relationship between a date field
in your parent table, and a name field in a child table? I do not understand
this setup at all. How can a date and a name be related, assuming that
you're using the fields to store data that represent what the fields are
named?
From what you're describing about being able to open the subform as its own
form, and being able to open the main form without the subform in it, I
surmise that the problem is the linkage that you've established in the
LinkMasterFields (the field or fields in the main form that relate to the
child table) and LinkChildFields (the field or fields in the child subform
that relate back to the main form); these links are the "joins" between the
main form and the subform so that the subform will display only the data
that are related to what is displayed in the main form.
I need you to tell me more details about
-- the tables that contain the data that you're displaying in the main
form;
-- the tables that contain the data that you're displaying in the
subform;
-- the main form's Recordsource (if it's a query, post the SQL statement
of the query); and
-- the subform's Recordsource (if it's a query, post the SQL statement
of the query).