An "type mismatch error" generally means that the system is expecting a number and you're giving it text, or vice versa. So, without seeing more of what you've got going on, I don't know how to help you.

Type Mismatch

When I manually change the ID in the table i get the mismatch error, but when I change it back I don't get an error

I watched the Type Mismatch video and went back and looked at the query that is the source for the form that gives me errors. The query is also giving me the same error when I try and change a ShowTitleStatusID. Here is the SQL for that query:

SELECT ShowT.ShowTitle, Min(EpisodeT.SE) AS MinOfSE, MenuT.MenuName AS Location, First(EpisodeT.DayNum) AS FirstOfDayNum, ShowT.EpTime, First(EpisodeT.EpTitle) AS FirstOfEpTitle, First(EpisodeT.AirDate) AS FirstOfAirDate, First(EpisodeT.Description) AS FirstOfDescription, ShowT.ShowTitleID, First(EpisodeT.EpisodeID) AS EpisodeID, First(EpisodeT.Day) AS FirstOfDay
FROM (ShowT INNER JOIN MenuT ON ShowT.LocationID = MenuT.IDMenu) LEFT JOIN EpisodeT ON ShowT.[ShowTitleID] = EpisodeT.[EpTitleID]
WHERE (((EpisodeT.EpStatusID)=4) AND ((ShowT.ShowTitleStatusID)=126)) OR (((EpisodeT.EpStatusID)=4) AND ((ShowT.ShowTitleStatusID)=142))
GROUP BY ShowT.ShowTitle, MenuT.MenuName, ShowT.EpTime, ShowT.ShowTitleID
ORDER BY First(EpisodeT.DayNum), ShowT.EpTime;