>I would use a slightly different approach. Create a table with a field to store each report name and a field to store the printer name (if you don't store the table locally, then perhaps a username or workstation name as well). Create a form to allow the user to select what printer each report will print to. When you print, check the table for the report and if it is found, assume that printer, if no match is found, go to the default printer (for those reports that don't require a specific printer to print to or the user has not made a selection for yet).
>
Hi Tracy,
This is a completely new angle, but it doesn't help me to solve the problem I'm trying to solve! :) I don't want to re-write the application (written by my late colleague, BTW), I just wanted to add a little bit of extra...
I went ahead and made report modifications to find, if the report was printed or not from preview/prompt. Now, if only prompt somehow keeps the selection (may be it does, I'm going to test in a moment), my problem would be already solved.
If it's not broken, fix it until it is.
My Blog