Validation is working fine now thanks.
1. Can't view Simple view of Recordset. It says the SQL is too complex even when it is the simplest query possible.(see attached).
Plus a few other errors where the recordsets aren't recognised when the page is re-opened.
This was all working until recently. I really don't know what is going on and I need this to work.