Referencing data in combo box

[Talon]

Basically MY problem is that i set the control id to that of a primary key so that when the combo box data is changed it puts the data in the table. However my problem is that the data it displays is a price and im trying to calculate a total. Therefore in VBA im trying to find out how to refer to the data displayed in the combo box but isnt the control source.

Thank you in advance
Any help would be much appreciated

 

[KenHigg]

Something like:

Me.Combo0.Column(1)

The column numbers start with 0. So the first column would be 0, the second would be 1, etc.

Hope this helps...