Using a validation rule with an update query
I have an query that updates a single line table that later gets exported as a CSV ready for upload into our Royal Mail system,
The table contains name, address, etc from our customer details tables, and weight, parcel type, and service from a form based on our despatch ID.
We occasionally have an issue where a foreign delivery mistakenly gets scanned through onto a domestic service.
I have now set up a validation rule and warning text using the postcode field and this all works fine if you manually update the field i.e. I get a warning if the postcode doesn't match "Right([Post_Code],3) Like '#[a-z][a-z]'" but if I update the field via my query I don't get any warning message and the update fails,
My question is, is there a way to get the validation warning to work when updating via the query?