Combobox returns multiple fields but not the ID number

[pattrickcolin]

I have a Combobox on a subform.
The Combo box is bound by the ID number.


The Combobox returns multiple fields.
Changing the column width to "0;3;3;......" it display the second field [product Name] etc

Q How do I return the id Number without displaying it.

[Bob Fitz]

I have a Combobox on a subform.
The Combo box is bound by the ID number.
The Combobox returns multiple fields.
Changing the column width to "0;3;3;......" it display the second field [product Name] etc

Q How do I return the id Number without displaying it.

It sounds as though it is already ready returning it. The first field which is probably the ID field is hidden by setting the column width property to "0". What is the the setting of the Bound Column prrperty and what is the setting of the Row Source property of the combo box.

[pattrickcolin]

Bound Column Property = 1

Row Source=SELECT DISTINCTROW [PARTSforDATABASE full].PartID, [PARTSforDATABASE full].PartName, [PARTSforDATABASE full].UnitPrice, [PARTSforDATABASE full].[1)Width], [PARTSforDATABASE full].[2)AspectRatio], [PARTSforDATABASE full].[3)Construction], [PARTSforDATABASE full].[4)RimDiameter], [PARTSforDATABASE full].[7)TyreName], [PARTSforDATABASE full].[5)LoadIndex], [PARTSforDATABASE full].[6)Speed-Rating], [PARTSforDATABASE full].Cost, [PARTSforDATABASE full].[8)FuelEfficiency], [PARTSforDATABASE full].[9)WetGrip], [PARTSforDATABASE full].[11)NoiseClass], [PARTSforDATABASE full].[10)NoiseBars], [PARTSforDATABASE full].[12)NotesOnTyre] FROM [PARTSforDATABASE full] ORDER BY [PARTSforDATABASE full].[1)Width], [PARTSforDATABASE full].[2)AspectRatio], [PARTSforDATABASE full].[3)Construction], [PARTSforDATABASE full].[4)RimDiameter], [PARTSforDATABASE full].[7)TyreName];

[Bob Fitz]

Your combo has three columns (PartID,PartName,UnitPrice) but the first is hidden. The first column is also the bound column, so that is the value that will be saved to the bound field in the forms Record Source.

[pattrickcolin]

Oh, now feel silly. Should have thought it through. The id nos was hidden, solved the problem.

[Bob Fitz]

Oh, now feel silly. Should have thought it through. The id nos was hidden, solved the problem.

Don't feel too bad. Sometimes we all have trouble seeing the wood for the trees.