Why is the expression builder changeing what I type?

[Guest]

When I build an expression in expression builder it will place brackets
around words after I have clicked okay. For instance, when I put in
"=[Subform].Form![SubformField]" after clikcing "OK" the computer will
automatically place "Form" in brackets, which is causing the expression not
to work.

 

[Duane Hookom]

Placing []s around Form will not cause the expression to not work. I expect
there is an error elsewhere.

 

[Marshall Barton]

When I build an expression in expression builder it will place brackets
around words after I have clicked okay. For instance, when I put in
"=[Subform].Form![SubformField]" after clikcing "OK" the computer will
automatically place "Form" in brackets, which is causing the expression not
to work.

That should not cause the expression to fail.

The brackets are added as a safety measure because names
with spaces or other funny characters must be enclised in
barckets. It's ugly when Access does not try to figure out
if the brackets are actually required, but it's should be
harmless.

The most common reason for that reference to fail is because
you used the name of the form instead of the name of the
subform control that is used to display the form.