Form isn't reading table records
This is a common error. Either you screwed up the 1:M relationship or you are trying to enter data into multiple tables incorrectly


From Microsoft's Developer Network MSDN :In a one-to-many relationship, you entered data on the "many" side for which there is no matching record on the "one" side. For example, this error occurs if you join a Customers table and Orders table on a CustomerID field, and then add an order using a CustomerID that does not exist in the Customers table.
From Microsoft Answers: It sounds like you are trying to enter data into multiple tables using one main form. That's not going to work. You NEED to be using subforms. Create your main form bound to the Members table and then subforms to each of the child tables. Use the Form wizard to create your forms.


My guess from your comments is #2. You added a new table but didn't recreate the form using subforms.