hallo,
in a form I have a combobox with two collums: ID and cost. The recordsorce of the combo is the ID. In the query I make it show the cost related to that ID. The ID collumn is hidden. In the same form I calculate a total and so I need to refer the value shown in the combo, but using the combo name automatically refers to the ID. HOw to do it?
in a form I have a combobox with two collums: ID and cost. The recordsorce of the combo is the ID. In the query I make it show the cost related to that ID. The ID collumn is hidden. In the same form I calculate a total and so I need to refer the value shown in the combo, but using the combo name automatically refers to the ID. HOw to do it?