Using value in unbound combo box in a calculation for another fiel

[Guest]

I've created a combo box. Col 1 is procedure code, col 2 is a rate. The
combo box uses the procedure code to look up a rate. I want to use the rate
value to calculate the total rate by multiplying it by the quantity field.
What do I call the field in my calculated control? Thanks for your help, cm

 

[Guest]

In the control source of the total field you can write

=[ComboName].Column(1) * [QuantityTextBox]

Note: the column count start with 0

 

[Brian Bastl]

cindy,

you need to reference the column index of your combobox control:

=[YourComboBox].[Column](1) * [YourQuantityTextBox]

HTH,
Brian

I've created a combo box. Col 1 is procedure code, col 2 is a rate. The
combo box uses the procedure code to look up a rate. I want to use the rate
value to calculate the total rate by multiplying it by the quantity field.
What do I call the field in my calculated control? Thanks for your help,

cm