Hi Garrett,

One of things you have to make sure of is that there are no wait states, including SET TRBETWEEN OFF. If TRBETWEEN ON, it won't happen.

I will try to put together a program that reproduces the problem. I created a quick grid to the orders table in Northwind but cannot reproduce the problem that way. There certainly must be a cofactor involved including a "SET WHATEVER" or even a connection property. Other possibilities include the fact that in the majority of cases, the code doing the REQUERY() is contained in a container of some sort. Whatever it is, I can assure you that =REQUERY(lcAlias) hardly works whereas lnResult=REQUERY(lcAlias) works almost all of the time. I just haven't pinned down the cofactor yet.

Hopefully I can isolate the problem. I'm working on it!

Cheers,
Bob