I'm getting behind - and lost.
however it doesn't seem to delete all the records from the tblUcase table when I run the qryLocationCase.
Because it's not a delete query.
And you said you knew how to run the procedure without using a form (which you didn't want), which is what you have to do to update the table. What I posted WILL work in any version, although you might have to update references to suit the older version (and I think you need a reference to DAO as well). I presume you know how to do that.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.