Harry,
Did you try putting the code from your cmdButton.click() method into the Keypress as I suggested? And did only the same one record print?
Barbara
>Dear Barbara,
> I have tried all your suggestions - no success. I am sure that the table has been selected. I was even confused because I apply the same method to print a report in another page with no problem. The other jobs (apart from printing) are fine. I really do not know why.
>
>Harry