Reports

Hi,

I'm building a program that will print a checklist. I have a database setup, and works, but I want to reproduce this in VB.

The DB has 4 jobroles, and I want to be able to select which jobrole is printed by selecting it from a dropdown list, then print the check sheet.

This I can do, to a point, I Have a button which has the following in it (testing an the moment):

Private Sub Command2_Click()
sSQL = "SELECT *"
sSQL = sSQL & " FROM Jobs"
sSQL = sSQL & " where Jobrole ="
sSQL = sSQL & Chr(39) & txtJR & Chr(39)
sSQL = sSQL & " ORDER BY Jobrole"
Data1.RecordSource = sSQL
Data1.Refresh
End Sub

I can change the txtJR to a different number and it will update the display. Now I want to do the same for the print but the way I see it, I have to create one report for each jobrole, but this changes.

Can I do the same as above but for the report?

I'm using the report in VB.

Thanks.