Rebecca,

Yes, I imagine you'd have to reindex it after each Requery(). The Requery() is basically giving you a new table each time.. I'd use a custom form method to handle the Requery() and indexing, and call it from Init() and wherever else you need.

>I tried setting indexes in the load of the form that uses the grid (because I could find nothing in the view definition that indicated an index--only a sort order). However, I have a requery in the refresh of the form because the user can add records. The requery lost the indexes as near as I can tell. Do I need to recreate them every time I do a requery????
>
>Thanks a lot for your help, this one has me stumped!