Hi Ray, thanks for the reply.
So, can I just check with you. If I do a search for the name 'Smith' and I am given 100 results on 5 pages of 20, in order to create a button which will show me all 100 'Smiths' id this is what I need to do?
Just thought I would clarify that it's not literally all the records I want to see, it's just the full set of 100 from that search on one page rather than 5 pages of 20 with paging. If this is what you understood me to mean and your answer is right for this then I apologise for being dim!!
Thanks yet again for the support.