Print a records from the last date the report was printed

[eshai]

hi:

i have a reports that every employed go to a end user pc enter his name and password and click print. it well print the jobs he have to do

my Q' is how do i set the report to print only the new records that created after the last print (i have a field for record insert date+time)

 

[Ranman256]

A form to print the report, it is bound to this table that holds the last Date printed.
The date shows on the form in a text box, txtLastday.

In a query to pull the data table, and use the text box as the criteria,
Select * from table where [date] >= forms!frmRpt!txtLastDay

Add a button to open the report.
Then update the LastDay.

 

[eshai]

A form to print the report, it is bound to this table that holds the last Date printed.
The date shows on the form in a text box, txtLastday.
.

didn't got you
where is the txtlastday
or i have to create a form with txtlastday
or...
or...

thank you

 

[Cronk]

If you want to "set the report to print only the new records that created after the last print" by any user, you need to record when that user did just that by storing the information in a table.

I would not use a form to display that date (unless you particularly wanted to display it)

Then base the report's recordsource on

Select {yourDataFields}from {yourDataSource} where {yourJobDate} >=" & dlookup("LastPrintDate","tblLastPrintDates","UserID=" & {yourUserID})