Cannot add data in from

[jamilian]

Hi

I'm a beginner with access so please bear with me.

I created a tab form and for each tab dragged the fields from the tables already created into each tabbed form, e.g. first tab is 'contact details' with various fields, second tab is 'inventory' with numerous fields etc. I created the one-to-many relationship I wanted for the tables before creating the form. For each field I dragged onto each tab, I bound it to the table by using the 'control source' in the properties list.
Furthermore, each table has a primary key and a corresponding value in teh tables to create the relationship to ensure its integrity.

At first it was working, i.e. the few tabs and I was able to add and delete data via the created form in any tab. Then, when I was completing the last few tabs required, it just stopped working.

Now it gives me an error message,

"The value cannot be added to this new row until the row has been committed. Commit the first row and then try adding the value."

Without delving into the code (as I'm no expert) is it possible to overcome this problem?

Can anyone offer any pointers or help on how to resolve this problem.

Much appareciated.

 

[HiTechCoach]

I created the one-to-many relationship I wanted for the tables before creating the form.

That sounds like the problem.

A form normally only enters data into a single table at a time. You would use a sub form for each table that is

Typically with a related tables as one-to-many :

* Main form bound to the tbale that is ont he One side

* A separate sub forms is used for each table on the many side of the relationship.