I got this marvelous code for printing labels a user posted on accessmonster.
com but the code seems to be preventing the report from actually printing.
Can't PDF or send to my Canon printer.

This code appears in the OnPrint event and I assume it's what's preventing
the printing. It previews fine just won't print.

Static intMyPrint As Integer
If PrintCount <= Forms!form3.Text13 And [SkipControl] = "Skip" Then
  Me.NextRecord = False
  Me.PrintSection = False
  intMyPrint = 0
Else
  [SkipControl] = "No"
  Me.PrintSection = True
  Me.NextRecord = True
  intMyPrint = intMyPrint + 1

  If intMyPrint Mod Forms!form3.Text14 = 0 Then
    Me.NextRecord = True
    intMyPrint = 0
  Else
    Me.NextRecord = False
  End If
End If

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200912/1

always just after I post...

Since it's an OnPrint event it's looking to the form for the values for the
actual printing. The db's been programmed to close that form once the Preview
is up. Problem solved, I will push the form values to a text box on the
report.

-- 
Message posted via http://www.accessmonster.com