Ok after revising the code to:
SELECT Subcats.*, productcategories.*
FROM Subcats
INNER JOIN productcategories ON Subcats.SubcatCategoryID = productcategories.CategoryID
ORDER BY Subcat ASC
... I clicked the test button in the record set dialogue and I was able to get the results, but again when I click ok to go out of the recordset dialogue I get the same error as before:
"Making this change would require changing code that is locked by a template or a translator. The change will be discarded."
Do you know what this means?