I have deleted the parameter criteria from that query and every area I can think of
Not sure where else parameter criteria could be located other than a query or code that creates a sql statement. Did you ensure there are no controls on the form(s) whose fields are no longer in the query?
Or maybe one form has a calculated control that uses a field that is no longer part of the query? Note that the subform opens first, then the main form, so you might want to try single step on the macro to see which form is driving the prompts.
If "Client" is the subform, the reference doesn't look right to me.
Not good practice to use special characters (#) in object/field names (save for the underscore).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.