I have an IIf statement in a Union Query that has been working fine forever. (Isn't this always the way?!) On ONE user's computer, this IIf statement doesn't work (causes an error). I have checked the VB references and they are all there (although I had problems with a missing reference on her computer before). I have double checked the problem on other computers and they all work with her login. Only on HER computer, does this not work.

Any ideas?

Ian addition to checking that the correct references are there, check that there aren't any extra references.

I literally read the references from one computer and checked hers. The references are identical.

Any other ideas?

What's the error?

It is:

Function is not available in expressions in query expression 'The IIf Statement'

This has happened to me. Reasons have been either, missing library, too many libraries or different version of libraries. Main culprite has been Office 9 library

That was it. I took the Word 9.0 library out and everything is fine. Thank you VERY much!