If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Store data from form in table associated with subform
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.... |
#2
|
|||
|
|||
Store data from form in table associated with subform
Annemarie wrote: 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.... 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? |
#3
|
|||
|
|||
Store data from form in table associated with subform
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? |
Thread Tools | |
Display Modes | |
|
|