Using 'Find' In a Combo Box

[Dugantrain]

I need to allow users to 'find' records based on the Team Name combo box. The problem is that the bound column is not the Team Name, but the TeamID Autonumber which is not visible. How can I allow them to search records by Team Name without their having to know the TeamID?

 

[Rob.Mills]

You need to have the bound name to the ID column. Have it display two columns and set the size of the columns to:

0";1"

Or whatever size you want for the second column

 

[Dugantrain]

Right, I have it set up that way, but the "Find" feature would only search the ID field and not the Name field. However, I figured out the problem. In the Toolbar, under Options, Edit/Find, you can change from Quick Search to General Search and it will search the needed field.