Annemarie wrote:
[Quoted Text] > 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?
|