>That's it. For a new record I do a lookup with an empty value (="") and of course it isn't found so doesn't enter the IF..ENDIF. I moved the SELECT nad it works fine. Thanks for all your help. I found it around the same time thanks to John. BTW Menachem, was that the translation you were looking for?
Yes it was. Glad you got it figgered out.