>I have turned off AutoClose on my views and they don't close but now I get a FoxPro Program Error: "SQL: Statement too long" when I go to close my form. I only get this error when I have data in the view. If I close the form without the view being populated then I don't get the error. Does anyone have any ideas what may be causing this error?!

how many fields are in this view? it sounds like it is trying to update the view when you close.