<resolved> Querry and print

[SaharaWizard]

Hello guys
I have run into an unusual problem, so I am trying to find an alternative solution instead of figuring out what I did wrong originally.

<b>Here is the question:</b>
I have an Access 2000 table with records of tickets. Each record has the following columns:
Id(long integer)-----Style(Text)-------RequestNo(Long Integer)-----PO(Long Int.)
I need to querry this table for all tickets with specific RequestNo and print all the tickets one after another.

What is the best way to do this.
I am using the following code to querry. HOw do I get the print thing to work?

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.ConnectionString = "B22"
cn.Open
rs.Open "SELECT Id, Style,RQN,PO FROM Rolls WHERE RQN = " & CLng(Trim(txtKRid.Text)) & " ORDER BY Id", cn, adOpenKeyset, adLockOptimistic, adCmdText
' Print thing should probably happen here.
 
rs.close
cn.close