ACC: Variable Not Defined Error with Yes/No Arguments

MORE INFORMATION

Most macro actions have a corresponding Visual Basic for Applications method for the DoCmd object. In macro actions, many times Yes and No are used in the different action arguments.

When you use methods of the DoCmd object, however, you must use either a system-defined constant, the underlying value of the constant, or a user- defined variable or constant that has been assigned the appropriate value.

Steps to Reproduce Behavior

1. Open a Visual Basic for Applications module and type the following function:
   

         Function TestYesNo()
            DoCmd.Setwarnings Yes
         End Function
   						

2. On the Run menu, click Compile Loaded Modules. Note that you receive the compile error "Variable not Defined" for the Yes argument.
3. Change the function to read as follows:
   

         Function TestYesNo()
            DoCmd.Setwarnings True
         End Function
   						

   Note that this function compiles and work correctly.