combo box bound column (1 Viewer)

[ycnan]

This may seem like a silly question, but it's driving me crazy.
I'm trying to use a combox box to choose tree names from a table that has speciesID, tree name, and abbreviation.
I have tried setting the bound column in both the form and underlying table to display tree name, but whenever I select anything from the dropdown box, it always displays the code in the first column of the table. I have tried changing the bound column to 1, 2, and 3 and still get the same results. Am I missing something obvious?

Thanks...

 

[Tiro Cupidus]

In your combobox, I think you'll want your bound column to be the ID field. Your column count should be 2 and your column widths should be 0",1", or something like it.