automatic fill in

[Dave B]

We have a form with two subforms, and in the subforms we
have the same field called "box name."

If we enter information on the first subform we want the
same information to go into the second subform.

Thanks!

 

[tina]

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