Wow! Thanks Gasman! This makes all the old code I have written (old meaning before yesterday ) so much easier to read.Yes, look tidy. Google Smart Indenter, to tidy up existing code. Plus you *could* type it in any old way and use it each time. You can indent the whole module.
Best to get into the habit though.
Now why is my second recordset empty? RS2 in my code in #11 When I run a query built exactly like it I get my records, but here nothing.