Quote Originally Posted by ben.oates
Also, make sure you don't have the same named field in another table because I didn't explicitly identify the field in the above statement as being part of a specific table in the switch statement. You might need to do that.
Aha, I think that must be the problem! I have the same named field in the tables that cause the problem. How can I identify which field I mean?