VB Code:
Set rsDis = New ADODB.Recordset sql = "select chkname, chkdate, chktotal, chknumtoword from checktable" rsDis.Open sql, cn Set DataReport1.DataSource = rsDis DataReport1.Sections(1).Controls("lblAccount").Caption = rsDis(0) DataReport1.Sections(1).Controls("lblDate").Caption = rsDis(1) DataReport1.Sections(1).Controls("lblTotal").Caption = rsDis(2) DataReport1.Sections(1).Controls("lblNum2Wrd").Caption = rsDis(3) DataReport1.Show
i want the next row of my recordset in the next page of the datareport. how? i am using vb 6. thanks!




Reply With Quote