Copying from one subform to another

[hiwelcome]

Hello,

Upon opening my database, the user makes a choice as to what two items he/she would like to open. After choosing and using the button, the two forms open as two separate subforms ("FormA" and "FormB") in a main form "Form1." These two forms are linked to different tables and I would like a number entered on FormA to be copied to FormB after update. I suspect I'm just not pointing to them correctly but haven't been able to get it to work (using http://access.mvps.org/access/forms/frm0031.htm). Any advice appreciated.

As an example, I tried

Forms!Form3!FormA.Form!TextNumber.Value = Forms!Form3!FormB.Form!Number.Value
Forms!Form3!FormB.Requery

after reading through a similar thread, but no luck.

 

[llkhoutx]

The requery is probably killing you change. Think about the data source of updated field is. Don't requery after the update.