Field Update "On Close" Event

[Guest]

I have a report that is based on a query that searches for a check box field
to be false.

Once the report is run, I would like to have a confirmation box on close
event that would update the checkbox field to true and updating my query.

Any ideas?

Thanks,

Brook

 

[SA]

Brook:

This is kind of an age old problem. The issue is, what if the user preview
the report, but doesn't print it? Do you still want to update the field?
Secondly, if the print fails (e.g. low toner,) do you still want to update
the field (assuming that the field is what pulls data into the report....

Its best to have a separate process for updating records, possibly run from
a form, where you have a separate preview button and a separate print button
and only after the print job is sent do you query the user about updating
the records (and you use an update query to update the rows in the table
based upon the records selected, of course this also gets a little nasty if
you have multiple users using the same reporting process simultaneously,
wherein you need to also think about control). For this to work properly
you normally create a separate menu bar and tool bar for your target report
that doesn't contain the print option. Then set those into the report's
properties so that when the report is previewed you can't print it. PITA,
but its about the only way it works (effectively that is)

 

[Guest]

Good Day SA,

That is what I am wanting to do, have the reports come to the screen (print
preview), then the user will manually print the reports, then on close of the
report (after a successful print), a confirmation box will pop up "Did the
reports Print Properly?" Yes will close and update / No will go back to the
preview.

Brook