Value From a Form
Value From Subform

Can get pretty tricky working with nested subforms.

    Forms!ParentFormName!Subform1.Form!Subform2.Form!FieldName

Thx yes you are right !!! I tried that sequence but i get the error 2489 the object (form name) isn't open is like when i'm working with subform2 both forms subform1 and main are not open at that time. So i'm not able to reference a control field from subform1 working on subform2. I will keep looking because how it works on the subform1 with subform2 on the footer section.

I'm getting confused about which Form the Button is on and what you are trying to reference. Please post some screenshots and what you have actually tried. It almost always help if we can see what you see.

Subform1 and Subform2 screens
Subform1 list all personal articles from the resident and subform2 list all In/Out transactions of the resident articles.
On the subform2 I’m adding 1 for PJ’s and the balance field on the subform1 is updated after I press “Yes”.
So it's working until i insert them on the main form that is the resident info

I see ONE Subform on a continuous form.

Here's the Main Form with the SubForms with the error message when i try to update the balance field on the Subform1 with the data entered on the Subform2 for the item PJ's selected on Subform1 for the resident (Robert Valentin) selected on the Main Form.

On the One Subform on a continuous form send before the field balance get's updated so it's working. I'm also looking on the source object name control and the Name control on the Other Tab is there's any in-congruence.

Looks like you need to Requery Subform1 in the After Update event of the field on Subform2
Try this:
   Forms!YourMainForm!Subform1.Form.Recordset.Requery

OK i will try that and let you know

Kevin i really appreciate all your help and support on this issue. I will stop for today and see if tomorrow a new day i can finally have this running probably i'm missing a simple / stupid detail that i don't see it today.

One thing that might be worth a try is creating a really simple form with next to nothing on it, short names and see if you can get that working.

Check the Name of the Subform control is spelled correctly.
Since you have an underscore in the name I would enclose them in square brackets (example below).

    Forms![frm_YourMainForm]![Frm_Subform1].Form.Recordset.Requery

Robert, take Alex's advice

I try with the form names between [] and get the same error 2465 cant find the field.
I will try then creating all the forms with short names from scratch and with just 1 or 2 fields and let's see what happens.

Hi, i really appreciate your time, help, guidance and patience lol!!! to finally fix this issue with the nested subform.

Just to let you know that finally is working looking at the video Value From Subform instead of typing the form full name i just type Me.Parent!Balance = Me.Parent!Balance + Me.CantPlus and the subform will resolve the name of his Parent Form so i don't know the reason why typing the full form name didn't work.

I'm curious does the FORM control Name located on the <Other TAB> should be the same name located on the control SourceObject on the <Data TAB>?