Can you run the query manually in a sql window?

Yes, I can put it into a new query and add a record without error. I want to say it has something to do with the link not being right or somehow incomplete but I have no proof.

Do each of the forms work individually?
(Maybe not if they need default values from linking etc)

Monica, I can tell you just from looking at that, that it's probably going to be too complex for you to be able to add records to that recordset. Not Updateable

I've watched the Not Updateable video, and it didn't help. The subform is editable, it's additions that cause errors. The old version worked from a query, and I've gone back to that, but it hasn't helped. The fact that it worked before has me at my wits end with them side by side on my monitors. The only two differences between the old query and the new one are that now the link fields have the same name and the order by field is new. The standing query is:

SELECT ShowT.ShowTitleStatusID, EpisodeT.AirDate, EpisodeT.EpisodeID, EpisodeT.ShowTitleID, EpisodeT.EpNum, EpisodeT.Season, EpisodeT.Episode, EpisodeT.EpTitle, EpisodeT.EpStatusID, EpisodeT.Description, ShowT.ShowTitleID, EpisodeT.EpTypeID
FROM ShowT LEFT JOIN EpisodeT ON ShowT.[ShowTitleID] = EpisodeT.[ShowTitleID]
WHERE (((ShowT.ShowTitleStatusID)=126) AND ((EpisodeT.EpStatusID)=4)) OR (((ShowT.ShowTitleStatusID)=142) AND ((EpisodeT.EpStatusID)=4))
ORDER BY EpisodeT.EpNum;

is "Allow additions" Enabled on your form?

Yes, I even added "Allow deletions.".

Hi Monica, you said the link fields are "listed with the table name for the child field but not the parent."  Make sure the link fields contain just the control names from the forms (not field names from tables) as shown in the picture below.

This is what I have. If I change it like you suggest it complains that it could be more than one field. I know this is because I have the fields from both tables in my query. However, when I remove EpisodeT.ShowTitleID and then try and open the form, it yells that EpisodeT.ShowTitleID isn't there. I've been thru the list of objects for both forms and named everything, even Text fields, and nothing is related to EpisodeT.ShowTitleID. Could it exist and not be in the object list?

You do not need the table names.

Why do you have the field twice in your Query?
it gives you no advantage and complicate things. try removing one from the query.

I did, please reference previous comment. As for why I did it in the first place, originally the field names didn't match. In the new version I changed that for simplicity and then changed the field name whenever I came across it. I did some copy/paste of forms as a short cut that now I think isn't so short.

Hi Monica,

This brings to focus what Richard, teaches in his courses from the beginning, and repeats often in the tech help videos. Good databases that are easy to maintain and code Starts with a good design of the tables not only in regards to the relationships, but also naming conventions.

I can talk about that because I did not start doing things right and for a long time, I banged my head against the wall trying to get Access to do what I want. Believe it or not, it is more efficient both in time and effort to go back and revisit your table designs. One error I have committed and still committing is the following: I change the name of a field. Access will carry forward that change in most places, but not all. The most common place that causes a lot of problems is when you change the name of a field on a form or report. The control source will change; however, the actual name of that control on the form or report will remain the same. Any reference forms and reports will be to the name of the control, not the control source. So, check that the control source and the field names are consistent.

At this point I think I just need to start from scratch with the forms.

Hi Monica, if you must have the same field twice, you must give them different and unique names by using "aliases" in your record source, e.g. SELECT Table1.ShowTitleID, Table2.ShowTitleID As ShowTitleID2 ... .  Then you can put the unique field names in the link master and child fields.  You can only put a single field name in the link master and child fields.  They don't accept table names.

I GOT IT!!! Apparently, I no longer need the linked field in the query OR EVEN ON THE FORM! Access just finds it in the background!!!!!! Thank you for all your help!