Get Value of Field Next to Another Field

[DanG]

Hello,

I know I've done this before but can't seem to remember exactly how.

I have a combo box called "PrintDevice" and the values for it com from a table called "tblPrintDevice", that table has a 3 fields (PDID, PrintDevice and PrintCostFactor). The row source for the combo box contains all three fields from the table, but the viewable field is the "PrintDevice".

As the user picks the Print Device it is the cost factor associated with the particular device that I want to have show in another field to or reference in VBA (not sure yet).

As I rememer it is something like "tblPrintDevice.3", but that doesn't work.

Thanks in advance

 

[pbaldy]

ComboName.Column(2)

the column property is zero based, so the third column is 2.

 

[DanG]

That did it!

Thank you very much.