Hi,

I have a CONDOform from my CONDOtable that has unit# as the primary key. Within my CONDOform, I have a subform that displays each individual that resides in each unit. The individual is assigned an ID# (primary key) and is from my DATAtable. The CONDOtable and DATAtable are "related" by unit#.

The problem I am having is when entering new condo info, I am unable to enter multiple ID#'s or individuals in my subform. I keep getting the error: "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."



How do I commit the row? Is there something wrong with my tables & the relationships that are preventing me from doing this?

Any feedback/suggestions would be greatly appreciated!
Thanks.