Form! vs Forms! in expression

[Wysy]

Hi,
In a form i made an unbound field to refer to a calculated field of the subform using the expression builder. It provided the Forms! object to refer to the field of the subform. However it gave a error #Name? . When i changed the Forms! into Form! it worked. What is the difference between Forms! and Form!?
thanks
Andy

 

[RuralGuy]

FORMS is referring to the Forms collection that does not contain your SubForm. FORM is referring to the current Form.

 

[Wysy]

Thank you! i just was confused by the expression builder. I thought it must correct, but i see now it cannot see that the form i referred to is a subform.
thanks
Andrew