Syntax Question

[NEWER USER]

I need help verifying which syntax is correct. I am referencing fields and
properties of subforms on a main form. A few examples below.
Forms!frmProduct!fsubRelations!Sales!ColumnHidden = 0
Forms!frmProduct!fsubRelations!Sales.Requery
"Number = Forms!frmProduct!fsubRelations!Number

OR should I use?
Forms.frmProduct.fsubRelations.Sales.Form.ColumnHidden = 0
Forms.frmProduct.fsubRelations.Form.Sales.Requery
"Number = Forms.frmProduct.fsubRelations.Forms.Number

The exclamation points seem to work, but which is correct? Should I always
reference subforms with ".Form."?
Thanks in advance

 

[Jeanette Cunningham]

Here is a link to all the info about syntax for form-subform code.
http://www.mvps.org/access/forms/frm0031.htm
Jeanette Cunningham