Syntax Question

  • Thread starter Thread starter NEWER USER
  • Start date Start date
N

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
 
Back
Top