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

  • Thread starter Thread starter Dan
  • Start date Start date
D

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.
 
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
 
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
 
Back
Top