>Remember we talked about that, and I TOTALLY agree.
Yep, I see that now: I had forgotten the details in the initial post.
>However, if you look at almost all code from books, MS, magazines, and here you will find that
>rarely if ever is REQUERY used in the lnResult=REQUERY(lcAlias) mode.
Hey, just because everyone else is an idiot doesn't mean you have to follow us over the brink. :-) I'm not sure I ever really realized REQUERY could fail: I would have written the code the evil way myself.
>However, I can tell you that with a live deployment, lnResult=REQUERY(lcAlias) and
>IF REQUERY(lcAlias) < 1 fails enough for the users to notice.
Ok. I'm running with what I have: if you find a way to consistently reproduce the above, short of sending your whole app, let me know.