Ok here is how my current form works. I have set up a form for users to fill out. Once the form or forms have been filled out there is a button at the bottom of the form. The button runs a qry to find any records that have been entered TODAY and generates a report based on that query.



The problem I have is that people entering these forms are not in the same timezone as the database. So if someone enters the form at 11.59 then clicks the print button at 12:01 the qry pulls no results. What I would like to do is change the qry to find any new records that have been entered since the last time they had run the print button on the form.

I was thinking of writing some sort of code that when the print button is press is runs the qry looking for records. After the qry has run the record has a field called Printed. The button then toggles a YES/NO trigger to denote that that record has been printed and will be omitted from the next time the person runs a qry by filtering it out.

THis may be the wrong direction, but I am not sure. Does anyone know of a way to qry all newly entered records by a sales person and not pull records that have already been qryed before.