value cannot be added to this new row until the row has been comitted. Commit the row

[janeyg]

I hope someone can help, I don't really understand the answers that I have seen to my problem. I am new at understanding this issue. I have two tables in access, I have created 4 forms. I have created a query for each form, drawing fields from both tables to use in these forms. When I try to create a new record in these forms, I get the message "value cannot be added to this new row until the row has been comitted. Commit the row first and then try adding the value" Please help, what do I need to do?

thanks
janeyg

 

[janeyg]

forgot to say, I am using access 2010.

 

[janeyg]

Dear Pat, thank you for your reply, apologies for my late reply.

1. I have two combo boxes on the form to select records from one table, both are unbound and run from a query from one table. I have created 4 forms in total, one combo box is used on them all, to select a record.
2.The forms are set a single form. All form draw fields from two tables. All forms are run from individual queries which draws from these tables.
3. I have one macro running in the event before update - which is Set value - date and time modified.
4. I have a few command buttons, which are - delete record, exit, next and previous record and add new record. All created by the wizard with no extra coding.
5. When I click the add new record, I get the message.

I am not sure whether I need to create a code to tell access to add the new record to both tables?

This problem with adding a new record started when I split my data into two tables, which I did because some information is used multiples times, so thought this should be seperated and organised better.

What other information can I supply to allow you to help me?

thanks
janeyg