Hi Sally,

>I'm not sure what you mean about re-generating the index from scratch.

When you requery the view it accesses the index of the table. If that index is corrupt, it would explain your problem. I meant, you shoul delete the index of the table (or all tables) that the view bases on and try again to requery the view.

Christof