I have a Datacombo control's datafield attached to a ADO recordset that I declare in code, and the rowsource,rowmember, & listfield properties connected to a recordset-returning command in a Data Environment.

My specific question: Does the Datacombo control change the datafield to which its bound when you select another choice from its list.
My DC is attached to a Address table that stores the State_Fk of State entries in a state table. When I select a different state with the DC it doesn't change the Address table's State_Fk to the corresponding value in the State table.

According to O'Reilly's "Visual Basic Controls in a Nutshell": "When used with two data controls, it can allow the user to select a meaningful value (such as a customer name) while writing its corresponding value (such as a customer code or some other unique identifier) to a database when a record is added or modified." -- But my experience is proving otherwise