write conflict

[skate]

I've tried searching for this but still can't figure it out. I have a write conflict whenever I close this form. I've figured out that the cause for this is a couple calculating functions that I've made up. Basically all they do is add up number from fields in a subform. I think the problem is b/c I have two subforms referencing the same table in tabs. I did this b/c there is not enough room to put it all in one subform.
I put in code to recalculate only based on which tab was being viewed. Of course this only worked if someone made changes to fields in one tab at a time (which is likely in my situation). I thought that was the solution and it did work for a while (for some reason), but now I'm back to square one and the write conflict still comes up.

Anyone have any suggestions?

 

[llkhoutx]

Try using just one subform on your form, setting the objectsource of the subform to the one which is appropriate..

 

[skate]

the problem is that i have so many fields that cannot be displayed in one form (at least in the format i want) so I decided to split them into two forms but both sourcing from the same table. After each calculation I put a save and requery. I'm still having the problem

 

[llkhoutx]

You've identified the problem correctly. When one subform updates, or trys to update, the other form thinks that it's data has changed because the recordsource record has changed.

Break your form into pages instead of tabs. You can navigate pages as easily as tabs and the problem you're having should disappear. To start a new page on a form, use the PageBreak on the Toolbox menu. You resulting form is can be up to 22" high. Can use buttons to setfocus on a particular page; goto bottom of the page, then to the top so as to have page fill the screen.

If you shave so much data that cannot be displayed on one form, you probably have a poorly designed table. Is you data normalized?

 

[skate]

the problem is my subforms need to be set to continuous, so the page break won't work for me.

 

[llkhoutx]

Your table which is the recordsource for your subforms is probably not normalized.

 

[skate]

what does it mean to normalize a table?

 

[llkhoutx]

Take a look at the following:

http://www.cctc.demon.co.uk/normalise.htm

It explains normailzation pretty well and gives and example.