Combo or list box on a form to select a role/name from a table or query

[Hardrock]

A form is used to enter details about an organization in a table. These details include name and contact info on the chairperson and treasurer. The names are stored in the fields "Chair" and "Treasurer"



A report needs to show the name of one or the other of these (chair and treasurer)....depending on who is going to sign the hardcopy of the report.

Can/should I use a combo or list box in the form to let a user indicate which of the officers will be signing? I'm trying to set this up so that the ROLES "chair" and "treasurer" appear in a combo box in the form and based on the users selection, the actual NAME of the chair or treasurer will show up on the report.

OR is there a better way to get the name of one of the two officers in the report AT THE TIME THE REPORT IS RUN?

Based on report requirements, the user MUST use the form any time the report is run since there are variables that must be input each time the report is run.

[June7]

Is there data in the report that can be used as criteria to determine which officer will sign? If not, then user must select. The report can reference the combobox by expression in textbox.


Or the name can be passed to report in OpenArgs argument of OpenReport.
DoCmd.OpenReport "report name", , , , , Me.comboboxname

Then expression can reference OpenArgs.
=[OpenArgs]

[Hardrock]

OK, I have a Chicken/egg issue here. I figured I can't use a combobox to choose a name on a form that I'm using to enter the name so instead my combobox lets user choose a role (which corresponds to a field in the table). So user chooses "Treasurer" which I'm storing in the table in a field called "Signer". How do I get the content of the signer field (which is treasurer) to help me get the actual NAME of the treasurer to show up on the report?

[Hardrock]

Solved. Here's the if/then statement I used to get the desired result:

=IIf([Signer]="Treasurer",[Treasurer],[Committee Chair])

So, depending on which ROLE the user specifies as the person who will sign the report, the name that corresponds to the role appears in an unbound text box in the report.