Allowing user to select what name and title to put on bottom of report

[Dan]

I'm creating simple reports: a letter and an invoice. The
reports open from a button on a form and take the data
from that form. However, I have a separate table of names
and titles (the user's names and titles). I want the user
to be able to select whose name appears on the bottom of
the invoice or letter. How is this done?

Thanks so much for any help.

 

[Fons Ponsioen]

On the same form where you take the data from create a
select or combination box with the names of the possible
users. You can either include their title here or create
a small subrepot and print a correcponding signature block.
Hope this helps.
FOns

 

[Duane Hookom]

Place an unbound combo box on your form that is based on the separate table
of names. Then reference this combo box in the control source of a text box
on the report:
=Forms!frmYourForm!cboYourCombo