cheekybuddha
AWF VIP
- Local time
- Today, 13:54
- Joined
- Jul 21, 2014
- Messages
- 2,288
Of course, Colin, when the test evaluates to false the false part of the IIf() (error part) is evaluated!
My point is, when you try the whole expression in VBA the false part throws the error even when the test = True, but no runtime error is thrown when used in a query
My point is, when you try the whole expression in VBA the false part throws the error even when the test = True, but no runtime error is thrown when used in a query