Updating Table from a Report

[elgoober]

Have a scrap report (model,date,qty,note no) and after report run - user has to go to a form and confirm in a yes/no field that scrap note for a particular entry has been actioned. Is there anyway to do this programatically - i.e.update the yes/no box after report is run.

Any help would be most appreciated

 

[Chris RR]

Only if printing the report guarantees that the user will do something with the items on it (then you could just run an update query immediately after creating the report, not hard in code.)

If there is any chance that an item (or items) would not be dealt with, then, sorry, your user will have to clean this up manually.

If it's the first case, and you need help with the code, just ask.

 

[elgoober]

It will be the former - and any code help would be most appreciated

Thanks for your reply

Paul