I am trying to get my database to print labels starting on a certain label. I found the code on "How to Skip used mailing labels and print dupiclates" on the support.microsoft.com website. However, I cannot get it to work. I just copied and pasted this code into a module in my database then I tried to put it on my report as suggested. I run into two problems when I do this:

Problem 1: My report does not show an On Print Event in the properties box.

Problem 2: I get an error when I type = LabelSetup () in the On Open event. The error message reads: "Compile error: Expected: line number or label or statement or end of statement". Then I tried typing Call instead of the equals sign. I didn't get an error message, but the code doesn't work.

Any suggestions as to what I could be doing wrong?

The OnPrint will occur in the detail of your report (plus the group headers and footers), highlight the detail section and you'll see an OnPrint event.

That did it! I put the code on the On Print event of the detail section of my report and it works wonderfully. Thank you very much for your help.

:) no problem, glad it was a simple fix. Reports drive me nuts!