write conflict - stumpped

[skate]

I have a write conflict error. I have a subform that adds 10 records and displays the data in a field in the main form. Data from the subform is based on one table, however b/c there are so many datafields in the table, it would not all fit in form view (at least in the format I need). So, I created a duplicate subform referencing the rest of the datafields in the same table. Basically I've got the first half of the table in a subform on a TabA and the second half of the table in a subform on a TabB.
I've narrowed it down to my adding function that adds the 10 records onclick of my "Calc" button. It only calculates for the current tab and requeries afterwards. I've figure that this popup only occurs on my first TabA not TabB and only on my initial entry/change of a value to sum in TabA's subform.
This has been driving my crazy! Any ideas? My table is normalized (all records are unique).

 

[Vassago]

That doesn't really clarify much. It could be possible that the query you are using on the first tab is locking the table, such as if you were using Totals, or using a union query, whereas the second query is not, so is not locking the table and allows you to add the records. Maybe if you posted a sample of the database or code here, I could take a look at it for you.