Subform

  • Thread starter Mail Merge Help
  • 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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top