Question Tabbed Form with Multiple Tables Issue

[thekey]

Hello Users

I was wondering if someone could help me solve an issue I have with Access 2007. I have created a database with approx 10 tables. I have also created a form with Tabbed pages and after days of work thought I had finally finished. I was wrong!

The tables are all linked with a common field and I have enforced referential integrity.

On one of the pages which relates to all the field in a particular table whenever i try to add data to it i get the error message:

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

Does anyone know how to solve this issue. I cannot understand it as on other pages with tables linked in the same way it is not an issue.

Thank you in advance for your help.

Thekey

 

[Guus2005]

First saving the record like the error suggests and then with an update statement changing the value of the field that gives the error might solve your problem. But it puzzles me where the error comes from.

HTH