DateAdd Function (continuation)

[JUDO]

Please see the attached code, won't work when going from 2003 - 2004. Previous code examples have been implemented but make no difference. Please advise, but not by zip file as we can't open them due to security settings.

 

[Rich]

There are several problems with your code, Date is a reserved word in Access and shouldn't be used as a field name.
DoMenuItem is obsolete and should be replaced with the RunCommand eqv.

 

[Mile-O]

Also, the errror trapping will stop you from pin-pointing the exact location of the error.

Comment out all the On Error statements and run the code. You should find out where, exactly, the problem is occurring.