value of field in main form be transferred to field in subform

[Guest]

Hi,

I would like my value from a text field in my main form once entered to
update the value of a similar field in my subform.

Main form refers to tbl_bundle as its control source.
Sub Form refers to tbl_docinput as its control source.

Main form field is text and is called AssignedTo
Sub form field is text and is called AssignedTo as well.

name of main form = frm_bundlelog
name of subform = frm_bundledocs

Basically what I have a table tbl_bundle that has the field BundleNo in it
that matches the Bundle# field in the table tbl_docinput. The Bundle table
provides the overview of the bundle, and the subform tbl_docinput provides
the view of all documents that are included in that bundle.

I would like from the main form to enter the person's name I am assigning
the bundle to, and once updated, the value is passed on to all the records in
that bundle. One catch, I want to later be able to change the value of the
AssignedTo on the record from tbl_docinput (in subform) to something else,
without affecting the whole bundle. Is this possible?

Your help is greatly appreciated.

 

[Guest]

Does anyone out there have any ideas on how to get this done?

 

[Guest]

Hi,

I would like to have a value from a field in my tbl_bundle (a bundle
contains many documents) to update the value of another field in tbl_DocInput
to this value, for all the records that match.

So something like this:

If [tbl_bundle].[BundleNo]= [tbl_DocInput].[Bundle#] then
tbl_bundle.assignedto = tbl_DocInput.assignedTo2

I need to have soemthing to do this to elminiate some data entry.

Thank you.