printing certain fields onto a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
jen said:
I have a form which i enter in our sales leads. After entering those i
Click to expand...
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
 
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
Click to expand...

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!
 
Back
Top