Extracting field data when a Record is selected

[Jeff Carlin]

Here's a simple, down and dirty solution.

When you create your form, add a 2nd combo box, set visible=false and populate it with the field data you want at the same time you populate your actual combo box. Then, in the actual combo box's click event, do this:
cboDummy.ListIndex = cboActual.ListIndex

Your dummy combo box will always hold the field data you want.