Subform

[Mail Merge Help]

Hi
I have a Main form that have 2 subform.

In subform2, I have the default value as below:
=[Forms]![apf20_ProjRecom]![ApF20_ProjRecomSub1].[Form]![status]


I created a record in subform1 and go to subform 2 to create a record. the
Status field does not copy across from Subform1.

But it copy across if I move to another record in Subform 1.

I suspect that Subform2 didn't recognise that a record has being created in
subform1.

Could you please help me how to get subform 2 that a record has being
created in subform1 so that it can copy the Status field across.

Thanks in advance

 

[Chegu Tom]

You may only need to force subform2 to requery.

In the AfterUpdate event of subform1 try (untested air code--you may have to
play with the bangs and the dots ! . )

me.subform2.requery
or
forms!mainform!subform2.form.requery
or
me.parent.subform2.requery