This query worked last year, but I've had the problem in two databases now this year. The error message says I must specify the table to be deleted from, but I have done that.
DELETE DISTINCTROW particyear.*, Players.DelNow
FROM Players INNER JOIN particyear ON Players.ID = particyear.PlID
The attached jpeg show my problem. The record I want to delete shows on a form, and I must confirm delete using "Delete Now"