report signature line

[Chummly66]

hey everyone,

I was wondering if anyone would have a suggestion on doing the following.

In my database, I have a button on a form which prints a letter which one of the techs would sign and mail to a customer.

Because we have multiple tech's, and the person who entered the work order info isn't necessarily the one sending the letter, I am trying to find an easy way where after clikcing the "print letter" button, the program would pop-up a form or somehow prompt the person clicking the print button for thier name or ID.

I have thought of making a simple form, where the user would select thier name or ID from a drop list, and then click OK to then print the report. Then I have to make sure the form also closes after the report prints automatically. I have also just tried leaving a unbound text box on the report and having the report prompt for the name, but its a pain having to type the name in each time as well as understanding that some of us cant spell <G>

Any thoughts or suggestions or what you would recommend would be appreciated.

Thanks!
Richard

 

[fneily]

You could create, as you said, a little pop-up form with a combobox that has their names. Then on the AfterUpdate event of the box, place something like:
DoCmd.OpenReport "ReportName"

Then on the OnOpen Event of your report, have something like: The following is changing the caption of a LABEL control:

Me![datehold].Caption = Forms![Sales_Date_Input_Form]![Start]

So set your caption or textbox.value to
Forms![ThePopUpFormName]![comboboxname]

Then on the OnClose event of the report, close both report and form.