I am newly for VB, I have created student remittance database in MS Access name "Student.mdb" table name is "Remittance" table having five fiedls name 1.Registration No, 2.Student Name, 3.standard, 4. bank name, 5. Amount. In vb i have designed one form "frmReport" in that i have placed two cmboBox, name "cmbstandard" & "cmbbank name" one command button name "cmdPrint"

My question is
1. I want to Print 30 Records per page

2. I want to print sum bank amount total in every pages and next page carry previous page amount total and sum curent page bank amount total.

3. I want to print Particular standard of the student and particular name of the bank(so i have placed two comboBox).

how to wite the code using with " Printer" object

awaiting your valuable reply

thanking you

First i would like to caution you.
  printing reports  in VB is a tough task for a newbee.

My Advice is that you use crystal reports for easy coding.

but if you insist here's some advice for you.
  for every page you print you should create a header and footer subroutine.
  you should store total amount for each page in a variable and for total pages in yet another variable and calculate them with each record.

  
As far as printer object is concerned you should print one line each time with printer.print method for easy coding. but you should calculate the text height and text width manually.

Note it would still be easier to use a Rich text box control and then use its .selprint method to print report but not as easy as crystal reports.