>>>I have a very simple view based on one table. It has been working fine for some days now. Today, however, everytime I do a REQUERY on it, VFP crashes completely. I deleted the view, deleted it from the form's DE, recreated the view, readded it to the DE. It still crashes.
>>>
>>>The code where the REQUERY is hasn't changed. The data in the table hasn't changed. I have been working on a different part of the program. I am positive that it is happening when I issue the REQUERY.
>>>
>>>Any ideas?
>>>
>>>-Michelle
>>
>>I will bet you a dollar that the crash is happening in a form with a grid... right? Check the controlsources of the column in the grid very carefully and you will find that one or more of the columns has funky controlsource.
>
>My first instinct was to scoff. I mean, what would the control sources in a grid have to do with requerying a view? But you were dead on! I had changed the name of some fields in the table, changed the view to match, but forgot to change the control sources in the grid!
>
>VFP could at least have generated a proper error instead of crashing. :)
>
>Thanks!
>
>-Michelle

So... you owe me a dollar. :-)