Subform

  • Thread starter Thread starter Mail Merge Help
  • Start date Start date
M

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
 
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
 
Back
Top