>Can you give me an estimate of how many fields I should stay under. I am building a mortgage application and I have 13 tables of which 5 have over a hundred fields in them. I created a view for each table so that I would have an easier time updating the tables. I can make the tables smaller hence making each view smaller. The wierd thing is that I issue an update just fine with my save button and everything updates just fine but I only get the error when I exit the form and only on the forms that have data on them. I don't get the error when closing a form with the same view but no data. Am I making sense?
You're making a lot of sense. Particularly since I programmed mortgage forms in DOS 10 years ago (1003s etc.). Needed 10 linked tables back then :-(
About the update: If your SAVE button is doing fine, then your view is probably OK.
1. Do you get the error if you click SAVE before exiting?
2. Are your underlying tables buffered? (Only the view should be buffered)
3. Do you have any code in the QueryUnload or any other event fired on leaving the form?
4. Can you open the debugger and check whether the view buffers are dirty (use GetFldState(-1)
This should give you enough for tonight :-)
Barbara