>You're right..it does have to do with table relationships... I just recreated this in the command window with two other views. One, which had multiple tables with persistent relationsips, behaved the same way. The other, with only one table, behaved as expected (ie returned records the first time).
>
>I'd like to understand what is happening here if anyone can explain it.
Did you try resetting the parameters(s) before requery()? Also, are any of the base tables buffered? (Just some vague ideas now :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.