Copying data from form to subform

[Steve via AccessMonster.com]

Is anyone familiar with copying data from a form into a subform. I have two
tables; One that holds Client data (MainClient] and another that holds that
clients family members [ClientFamily].

On my form, the master record source comes from the MainClient table and then
the subform record source is ClientFamily. The subform is linked by SSN,
however the ClientFamily table has a [SSN] field that is linked to the
ClientFamily table and then another field called [SSNF] which is the family
members SSN.

Since the ClientFamily table MUST include the client, which is entered in the
Main form, I'm wondering how to take the name from the MainForm and copy it
to the name field in the subform as the first family member automatically.

 

[Guest]

Hi Steve,

Generally having the same data copied across multiple tables is a bad idea.
You can always get the data through your table links... You could have your
main form hold the family details and your subform hold the family members
with a checkbox to indicate the "main" family member...

However, in answer to your question, the easiest way would be to have a
command button that you click to copy the data across, by way of an SQL query
or code.

Hope that helps.

Damian.