The value cannot be added to this new row until the row has been committed.

[Perfac]

The value cannot be added to this new row until the row has been committed.
a. This is my input form for Receipts. The problem is not on my running app.
b. I work on a copy as always. I do not know what I changed for the error to appear on the copy.
c. Once before I set Recordset Type on the form and query to "Dynaset (Inconsistent Updates)" Then a new error comes up.
d. I copy the original again and then the error comes up again on the copy, after I did some work on the page.
e. The Payment form is set up exactly the same but does not return the errors. I copied the Payment form over the receipt form and changed the links of the fields then the errors reappear.
f. I surfed quite a bit and try to learn what the issue is but no luck yet.
g. The error happens when I click on the sub form combo box displaying "Debtors".


Another error on the Receipt form of the copy I work on.
The payment form has the exact field and is linked to a query exactly the same way, and the Payment form does not error.
The error happens when I click on the combo box displaying "Absa Oakfield".

Dit maak my tiete lam.

[ranman256]

You must save the master record before you can add child records.
and sometimes any needed parts of the join.

[Perfac]

My app has over 150 main forms, of which 100 got sub forms. As you can see there is a Save button on every form. Even when I click on save after capturing the master record, it does not solve the error. But I have no "save action" on the other 100 forms with sub forms. As far as I know this is the only form where I experience the error. I try to learn what the solution is here. I experienced it before and found fixes without knowing what went wrong. Seems like I will struggle here for more hours and then find a fix without learning what the cause was.

[Welshgasman]

Well the error message states what the problem is?
I would inspect what you think is the correct key to the one table and what the one table key actually is?

[NoellaG]

The error "The value cannot be added to this new row until the row has been committed." indicates you're trying to update a field in a new record that hasn't been written to the disk yet. Have you tried to set a waypoint in the first rule of the code that is executed and step through the code to see which line generates the error?

[Perfac]

Thanks. I will test and report back. I wonder if Flemish is your main language, mine is Afrikaans which is probably 90% the same.

[NoellaG]

Yep, ik ben een Vlaamse, geboren niet ver van Gent en woon niet ver van Antwerpen

[Perfac]

Aangename kennis meneer. Ek is nou 60 maar op skool het ek n vriend Koen De Ruyk gehad wat van Belgiee gekom het, met sy ouers en familie. My voor ouers was seker Hollanders, maar ek was nog nooit uit Afrika nie.