Combo Box - List of Names but only want 1 name to print from form

[ClassyD]

I am able to pull data in a combo box, but only want 1 of the names to print from the Form. Currently I'm printing all the names instead of one letter.

[RuralGuy]

Your requirements are a little fuzzy. How are you "printing" the names from the form?

[ClassyD]

I'm sending the form to .pdf

[RuralGuy]

What code do you use to "send the form to .pdf"?

[ClassyD]

No Code; I'm clicking on the icon. The query I'm using pulls back two records in the drop down list. Both record is pulling even though I'm only selecting one.

Will something like this work to display the selected record only?
Have an unbound combobox with a list of name - DISPLAY ONLY once the item has been selected.
In the AfterUpdate event of the combobox,
DoCmd.GoToRecord,,,acNewRec
Me!ContactsID=Me!combobox

[RuralGuy]

I'm sorry but I do not have ac2016 so I will probably not be of much help. I'll see if I can find someone with ac2016 for you.

[CJ_London]

it could be something to do with your combo rowsource.

Can you provide the sql to the combo rowsource plus combo properties of bound column, column count and column widths. Also some example data.

my guess is your rowsource is something like

Select lastname, firstname from tblnames

bound column is 1

column count is 2

column widths 2cm;2cm

and what is happening is your rowsource produces something like

smith, john
smith, james

[ClassyD]

I'm using a query.

The query pulls back two records.

Marty James
Cathy Smith

The combo box allows me to select Marty James, but when I send the record to Cathy Smith is included.
You know what, I think the problem is originally I built the code to show me Marty James. But the user want more than one name to appear so anyone on the list can
process the record. Adding the additional name has created the problem.

[CJ_London]

OK, that blows one theory out of the water. But still need to know the sql to your query plus combo properties of bound column, column count and column widths.

you say you have no code, just click on an icon. And what icon are you talking about? one in the ribbon, on the form? can you send a screenshot because I am struggling to picture what you have.

[ClassyD]

I used a report and have completed this. Thanks for your help. Mark Done!

[RuralGuy]

I marked this thread as Solved for you. There is a link to the directions on how to do this in my signature.