Store data from form in table associated with subform

  • Thread starter Thread starter Annemarie
  • Start date Start date
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....
 
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?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Using form and subform not connecting to two separate tables 0
Trouble associating parent form record to subform's record 1
Using an append query in a subform 1
Unremovable horizontal scroll bar on subform 1
Records in form and subform 1
How to always get the top level form reference, when calling from any subform/subform... 0
Set Change Event on Control from Nested Subform 0

Back
Top