I can get the first page to print using a wizard to make a print buttion but that only works for the first tab. This button just prints out the first tab and only the record selected. When I use the same method for the other tabs it prints all the records. Is there any way to select each tab separately to print.

Would be grateful for a reply just need this to finish my project.

Thanks!

The recordsource for your second tab re;ort is incorrect.