---------------------------
Microsoft Visual Basic for Applications
---------------------------
Compile error:
Argument not optional
---------------------------
OK Help
---------------------------
In the above equation, if [COMPLETE] is a string and its value is "No" or "False" it will evaluate to True. You need to do the right type of comparison on your fields.
If [COMPLETE] is a string you need to set the right side ="Yes" or ="True". If it is a Yes/No datatype then you can use the experession you posted.