Problem with default date value

[Amer]

I have one date field in a subform where the default value of which = Date
(). Instead, the field displays =Name?

How to solve this matter as it is only happening with subforms?

 

[Danny J. Lesandrini]

Amer:

The =Name? error suggests the ControlSource property contains
something that cannot be resolved. What do you have in that property
and is it a valid column name?

 

[Jeff Boyce]

Are you sure it doesn't say "#Name"? That's Access' way of saying "I don't
recognize the name of the field or function you just gave me."

If "Date()" is generating that, your database probably has a missing
reference.

Open a code module, check references. Uncheck any reference marked MISSING
(and note which one{so}). Close the window. Re-open the references and
re-check the one(so) that were MISSING before. Close the window.
Re-compile.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Amer]

Yes it is "#Name"?, sorry.

Now it worked: I checked the references and found one missing and did as you
adviced me. Thanks a lot.