Control Code Placement

[DaveB]

I don't know where to put 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!!!

All I want is 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]...

 

[Michel Walsh]

Hi,


Have you take a look at http://www.mvps.org/access/forms/frm0031.htm

Basically, you miss the keyword FORM, in this case.



Hoping it may help,
Vanderghast, Access MVP