Formerly updatable query no longer updatable

[Bill R via AccessMonster.com]

I have been using this query as a recordsource for a form in development for
several months:

SELECT tblDMSData.*, tblFilteredDMSIDs.[Select], [Week Ending].[Week-end Date]

FROM [Week Ending] RIGHT JOIN (tblFilteredDMSIDs INNER JOIN tblDMSData ON
tblFilteredDMSIDs.DMSID = tblDMSData.DMSID) ON [Week Ending].Dates =
tblDMSData.[Recovery Date]
ORDER BY tblDMSData.DWG_NO

All of a sudden, it has become a non-updatable query. I had been using the
check box in the local table, tblFilteredDMSIDs, consisting of a subset of
"DMSID"s and a "Select" checkbox in the form, to filter a table ("tblDMSData")
of drawings in the Back End on the server. Believe me, I've been checking and
unchecking that local table check box at will and changing some of the
backend tblDMSData fields from this form for months. Now it's become non-
updatable. Any suggestions would be deeply appreciated. I can't think of
another method for doing this, short of importing the tblDMSData into every
Front End. I obviously can't add the checkbox to the tblDMSData in the back
end, because that would filter everyone's records. I'm trying to permit users
to filter the backend data for just those records they're interested in, and
to use the check box in their local filter table to create a subset of those
filtered records.

Thanks,

BIll

 

[TC]

Without reading your whole description of how the statement works:
check the primary keys and relationships for the relevant tables are
still defined correctly.

HTH,
TC