Store data from form in table associated with subform

A

Annemarie

I have a subform linked to a form. I know how to copy the data from
the main form onto the subform...

=[Forms]![FormName]![FieldName]

but how can I store this data in the table associated with my subform?
I need this information for reference on the subform table to keep the
relationship between tables, but don't want users to have to re-type
this information each time they use the subform if they just typed it
on the main form.

please help....
 
P

pietlinden

Annemarie said:
I have a subform linked to a form. I know how to copy the data from
the main form onto the subform...

=[Forms]![FormName]![FieldName]

but how can I store this data in the table associated with my subform?
I need this information for reference on the subform table to keep the
relationship between tables, but don't want users to have to re-type
this information each time they use the subform if they just typed it
on the main form.

please help....
Click to expand...

Why would you want to copy the data at all? If the data is in the
parent record, you can get to it from any child record by using the
relationship. Could you explain the circumstances a little. I don't
understand why you would ever want to copy data from the parent record
to the child. Or are you using this as a default?
 
A

Annemarie

It is needed to keep the relationship. The main form pulls from a
different table as the subform. I need the fields in both tables to
maintian that relationship otherwise there is nothing linking the two
tables. It along with another field are among the primary keys in both
tables. I need this field in both forms as a reference, once the form
appears, as well as needing it to record in the table associated with
the subform to maintain that relationship between the two tables.
Otherwise there is no way to link the subform data to the main form.
There are multiple entries on the subform for each entry on the main
form or else I would have condensed this to one table. The fields must
be on both in order to enter them for each subform record. Does this
make sense?
 
Top