>I have two forms in my app which issue a REQUERY to a parameterized view with the following definition.
>
>
>SELECT *;
> FROM ofax!orderitems;
> WHERE Orderitems.report_num BETWEEN ?cOrder_ID+"-01" AND ?cOrder_ID+"-99";
> ORDER BY Orderitems.report_num
>
>
>When this statement is executed from the Forms it causes VFP to crash ("This Program has performed an illegal operation" etc., etc.).
>
>But
>When in the view designer I can run the view without difficulty.
>And
>Likewise, I can issue the REQUERY() from the command window with no problem.
>
>I've rebooted, removed the view from my Database, packed the database, rebuilt the query, tested it with-ih the designer, and in the command window. I also removed the view from the form and put it back in again. I then rebuilt the app and ran it.....
>
>Same results....illlegal operation when trying to run the requery in the form.
>
>Oh yeah, I almost forgot....it worked a couple of days ago. The view has not been altered. However, I recently changed the structure of the OrderItems table. (added 2 fields)
>But like I mentioned, I've re-built the query since then, and it works outside the form.
>
>Any help would be appreciated....
>
>Rick


Turn your attentions from the view to the form. My guess is that you have a grid on the form that is based on the view, and one or more of the columns has a funky controlsource. If not, check and double-check the controlsources of all bound controls on the form.