Lengthy Message when trying to enter data in Combo Box Access 200

R

Raas

I have a form with three combo boxes on it. Two of them work just fine when
trying to do a dynamic update. The third one displays a message at the
bottom of the screen the minute I try to type anything in the box: "The
value cannot be added to this new row until the row has been committed.
Commit the row first, and then try adding the value".

What is this trying to tell me? How do I "commit the row first". What row?

The first two combo boxes are related to the parent table through
non-primary keys, just through fields common to each.

The one that give the above message is related via the primary key on the
parent table, in a one-to-many relationship to a foreign key on another
table. The table that has the bound combo box in it.
 
Top