opening forms based on report records

[potts]

Is it possible to have a form open and display records to be printed based on the date a report was printed?

I have created an invoice that has an unbound field to display the date it was printed - DateSent: =date()

However, I want to create a form, probably with a list box, to display the accounts that have not been paid 90 days after the invoice was created.

 

[Adrianna]

Just an idea.....

On the print button you could insert some code into the OnClick event that would update a DatePrinted field of all the records in your report. Since I'm imagining that you're report runs on a filter/query...you would have to run an update query to do this!!!

Good Luck!