Hi,  i have a big problem with printing the
bill that i created in vb6.
when the print command press the printer print
only the first record from the recordset.
the recordset that i created is not refreshing
if i make second bill the printer prints the first records onlyy.but the data is saved inthe recordset.
Please helpppppp me.
thanks
miss.

You can use requery to  refresh the Data.

for example

rs.requery


From your question what i understood is , you are printing only one record. But the data's are avaialble in the recordset.

So you can use your printing process within the loop.

Do until rs.eof
   'Write your printing code's
   ----
   ----
   rs.movenext
loop

BY
Chris