Update date when report is run (1 Viewer)

[Agism]

I have a database that creates a test based on criteria selected by the user. The second portion of this database keeps track of employees, when they took each test and what their score was.

There are 17 tests each employee will take. And, each employee can take the test a maximum of 4 separate times to pass. There are date fields for each trial of each test (4*17).

I want access to update the proper date field for the employee taking the test when the test is printed.

Anybody have any great ideas? I have a few ideas floating around, but have yet to put it all together.

Thanks!

 

[Rich]

Use an update query or DoCmd.RunSQL when your report is run to update your field.
HTH

 

[Agism]

That sounds easy. Wonder why I didn't think of it.

Thanks!