I have a report that only opens with the first page(record). Any ideas?
Code:Private Sub cmdPrintWO_Click() Dim strLenPrintOrderSQL As String strLenPrintOrderSQL = "SELECT * FROM LenoxOrdersPrint" DoCmd.OpenReport "LenoxWO", acViewPreview, strLenPrintOrderSQL End Sub