access 2007 macro conditional expression error
Posted on 2007-10-02
I have a MS Access 2003 application that I want to open (unconverted from access2003) using Access 2007.
A problem occurs when my macro hits the line where there is a conditional expression command()="" .. I get the message 'the expression you entered has a function name <appl> cant find'? It does not like the reference to command() but the command() works if I use it in a VBA module. Also, if I remove the conditional expression the macro runs fine. The macro runs fine under access 2000, 2002 and 2003.
What is the problem Access2007 is having and how do I solve it?