>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?!

Steve, you'll get this error when you have too many fields in the view. "Too many" is vague, because there isn't a specific number. Are ALL of your fields required in the view? You should include only fields that will have data changed, so perhaps you can use less than 120.

HTH
Barbara