Why is the expression builder changeing what I type?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Placing []s around Form will not cause the expression to not work. I expect
there is an error elsewhere.
 
cali_meleah said:
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.
Click to expand...


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