Code Update

[DaveB]

Just need some help placing my subform names and field
name in the code below. Please let me know if the code is
correct and where to place my controls in this code.
Thanks!!

I want the BOX NAME information from my first
subform to go automatically into my second subform.

First subform is called: BOX TABLE subform
Second subform is called: CONTENTS TABLE subform
Field name is called: BOX NAME


Try this code;
Me.Parent!SecondSubformCONTROLName!BoxName = Me!BoxName

Try This code:

Me.Parent!SecondSubformCONTROLName.Form!BoxName = Me!
BoxName

********************************************************
put the code in the first subform, in BoxName's
AfterUpdate event, as

Me.Parent!SecondSubformCONTROLName!BoxName = Me!BoxName

make sure you use the subform CONTROL name, rather than
the name of the subform. to get the right name, open the
main form in design view. click once on the 2nd subform
*in the main form*, to select it. in the Properties
box, click the Other tab, and look at the Name property.
hth

message
news:[email protected]...