As I said, you may need to pass a parameter. Now back at my machine and can confirm that is the case. Example sql - note the criteria which 'resets'...
Thank you - this looked the most hopeful reply. Unfortunately I have not got it to work. Running with a stop of the rownum function - then yes it is...
The code executes but the relevant nodes are not bolded. I tried putting the subroutine in Form_Open and the code works as expected. I have a subform...