Signature block on Letter

[Novice1]

I have a report with a signature block that changes depending on who prints the report. With one record this is easy. The user selects a person from a option field.

My problem is that I have a letter that contains names from several records. How do I create a signature block in which the user chooses from a list? I tried a subform and subreport but this cannot be done with a continuous list form.

Any ideas?

 

[Ranman256]

On the form,put a drop box of the names for user to pick.
If only 1 name,no problem.
If > 1, user picks, then report reads the cbo box for signature.

 

[Novice1]

Thanks ... I had the combo box in the form (one name) but my report didn't show the signature block. I don't know how to refer to the combo box in the report. Thanks for the help

 

[Novice1]

I have the combo box on the form (pull from technician list). I need to pull record information related to the Name I selected from the cbo.

I don't know how to reference the data from the cbo in my report

=[Forms]![frmRetrievedPassports]![SigBlockCombo]![LastName]

Help please

 

[Novice1]

My combo box on my form is unrelated to the data on the form (combo box for signature block info such as name, title, position, etc.). The combo block referencing a table of technicians (lastname, firstname, title, position). The combobox shows only the last name of the person.

The problem I'm having is referencing the fields in the technicians table. I can pull the data from the cbo with =[Forms]![frmRetrievedPassports]![SigBlockCombo] but I don't know how to reference the other related fields in order to build the signature block. I've looked and looked. Help please

 

[Novice1]

Resolved: I created a sub-report (with the signature block). I then filtered the signature block with the SigBlockCombo. Thanks Ranman256