Jeff,
This is pretty simple-minded, but have you done a grid refresh as part changing the dropdown lists? Also, if you are requerying the view without doing a tableupdate(), you should probably do a tablerevert() to clear all buffered data out of the view before the Requery() is called.
HTH
Barbara
>Hi everyone,
>
>I have a form that has a grid using a parameterized view on it. I have 2 drop down list that contol what is displayed in the grid and I am running VFP 5.0A.
>
>Here is the problem. If I make a change to a field in the view but do not leave the field (Tableupdate is not called) and click on one of the dropdown lists and change the parameter when the grid gets focus I get an error "Record is out of range". While debuging this I see that when I get this error the view shows 0/6 in the status bar. If I go to the command window I can requery() and get the 6 records but when I resume and click back on the form I get the same error message.
>
>I know that the Record is out of range error message usually means to reindex. I have done this on the base table but the problem seems to be with the view. I do have indexes on the view but they are recreated everytime I change the parameters.
>
>Any Sugestions?
>
>TIA
>
>Jeff Whitaker