Date problem

[Guest]

I need to have the date a check box was clicked stored in a table.

I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

When I click the check I get n error which says "The expression you entered
has function name that Microsoft Access can't find"

I don't understand. I have done this before with no problem.

When I change the expression to Now() it works fine, except I can't easily
total the number of checks per date.

I wrote a similar question over the weekend, but my facts were not exact.

 

[Guest]

Sometimes Access doesn't recognise build in functions when there is a
reference missing, open the code (doesn't metter where) selct in the menu
Tools > Referece.

Check if there is an indication next to the reference that is missing