printing certain fields onto a report

[jen]

I have a form which i enter in our sales leads. After entering those i print off each report and give them to the salesman, i need to know how to print the forms/ data that has not been given to the salesman. i need to get a report that shows which sales leads i have NOT sent to the salesmen ye

 

[Pieter Wijnen]

you could always put an update statement into the reports detail_print event
to update a field in your table & check against that

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next
if PrintCount= 1 Then
CurrentDb.execute "UPDATE table SET Printed = TRUE WHERE key = " &
Me.Key
end if
End Sub

I have a form which i enter in our sales leads. After entering those i

print off each report and give them to the salesman, i need to know how to
print the forms/ data that has not been given to the salesman. i need to
get a report that shows which sales leads i have NOT sent to the salesmen
yet

 

[John Vinson]

I have a form which i enter in our sales leads. After entering those i print off each report and give them to the salesman, i need to know how to print the forms/ data that has not been given to the salesman. i need to get a report that shows which sales leads i have NOT sent to the salesmen yet

You will need to base the Form on a Query that selects records from
the table that have not been sent to the salesman. You will
(obviously) need some field in the table to indicate that it has been
sent or not - Access can't tell!