I can't add new records to my form

[Access_Novice]

The attached Word file shows screen shots of what I am working with.



1. Figure 1 shows the form I am working with. There are 12 records. If I have any record open, I can edit them and the underlying table will update. So far so good. But when I attempt to add a new record, I can't type anything in a field.

2. The form above is based on a query called qryMembership. Figure 2 shows this query.

3. Figure 3 shows a diagram of all of my tables and how they are related.





A. When I try to enter something in the first two form fields (Parent and Gymnast), the status bar says these fields are Read-only. Why are they read only?

B. I can successfully enter a number into the Class field. No problem there.

C. When I try to enter something in the Tuition and Discount field, I get an error message: "Cannot add records; join key of table 'Membership' not in recordset. What does this mean?

D. Total Tuition is also read-only. Why?


If you would address each point above (except for B), this would really help me out a lot.

[Bob Fitz]

Try adding MembershipID to the query.

[Access_Novice]

Try adding MembershipID to the query.

I tried adding membershipID to the query. It didn't work.

[Bob Fitz]

You might try adding the PK's from the other tables to the query. You may also have to have controls on the form bound to them.

[Access_Novice]

You may also have to have controls on the form bound to them.

I think this might be the answer. However, unfortunately I have since deleted (by accident) the tables I was working with. I just deleted the Parent table, but all other tables downstream were also deleted. Undoubtedly because referential integrity was enforced along with that option about deleting records.

I will keep your suggestion in mind. Thank you sir.