#Name?

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello.
I imported tables and forms from another database.
All works ok except for one thing.
There is a date control in a subform whose default value is set to Date()
which should default to 'today', but show's the dreaded #NAME?

I have compared the control on the other original form, and every other
control property in the main form and the subform, I've compared the queries
that are the sources and everything in VB but they are identical and so are
the tables so I'm at a total loss.
Please can anyone tell me what this could be.
Thank you
Jen
 
WEIRD!! I've just opened the database on another computer, and no error on
the date control!!!
am I going mad?
Jen
 
I'm not sure why it is working elsewhere - you should NEVER use a reserved
word as the name of a control. Date is a reserved word. Try renaming it to
StartDate or whatever is suitable and see if that works.
Mich
 
Ok will do Mich, thanks for the tip
Jen

M Skabialka said:
I'm not sure why it is working elsewhere - you should NEVER use a reserved
word as the name of a control. Date is a reserved word. Try renaming it
to StartDate or whatever is suitable and see if that works.
Mich
Click to expand...
 
Back
Top