I have a combo box populated using .additem with three fields from a recordset.

When the user selects an item how do I determine what record they are on? Can I bind the Combo Box to work like the ADO Control where you can navigate through a recordset by using the combo box?

I have tried using .itemdata and other properties with no luck.

There must be a standard way of doing this because combo boxes are used in almost every database.

----------------

Would it be easier to use the DataEnviroment? I havent found much documentation on it. Can it do everything you can do using code to make the connections and generate the recordsets?


Thank you,
Coopetj