Skipping Used Mailing Labels

[LadyDi]

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?

 

[converse]

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.

 

[LadyDi]

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.

 

[converse]

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