expression

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hello, I'm having a problem with the following statement;

=[Forms]!frmCLASSTIME BEAUDRY C!DATE

I have it on a report that is supposed to pull the date
from the DATE field off the form "frmCLASSTIME BEAUDRY C",
unfortunately it is giving me the following error #Name?
I'm not sure if I'm writing the statement correctly.
 
Put square brackets around the form name, since it contains spaces:
=[Forms]![frmCLASSTIME BEAUDRY C]!DATE
 
Martin said:
Hello, I'm having a problem with the following statement;

=[Forms]!frmCLASSTIME BEAUDRY C!DATE

I have it on a report that is supposed to pull the date
from the DATE field off the form "frmCLASSTIME BEAUDRY C",
unfortunately it is giving me the following error #Name?
I'm not sure if I'm writing the statement correctly.


Names with spaces or other non-alphanumeric characters must
be exclosed in square brackets.

=[Forms]![frmCLASSTIME BEAUDRY C]!DATE
 
Back
Top