Combo Box Value in Calculation

[LJG]

I have a tabbed form with one of the form calculating lease values. If I
enter calculate number *0.035* it all works fine, however as rates may vary
I have a rates form that has a combo box to select the rate value. the code
I have is:

=frmLeaseRates.Form!cboRates!column(1)*[txtCashSum]*12/52

This give me an error, I assume therefore I am referencing the combo
wrongly...any tips anyone?

Also I have default value of 0 in a number of fields and want it to be the
same colour as the form, so it appear invisible unless in is >0 the form
colour is -2147483633 the standard grey colour.


Thanks
Les

 

[John Vinson]

I have a tabbed form with one of the form calculating lease values. If I
enter calculate number *0.035* it all works fine, however as rates may vary
I have a rates form that has a combo box to select the rate value. the code
I have is:

=frmLeaseRates.Form!cboRates!column(1)*[txtCashSum]*12/52

This give me an error, I assume therefore I am referencing the combo
wrongly...any tips anyone?

Try

Forms!frmLeaseRates.cboRates.Column(1)

to get the second column of the combo (it's zero based). If the
expression is on the same form you don't need the full reference -
just

=cboRates.Column(1)*[txtCashSum]*12/52

should work.

Also I have default value of 0 in a number of fields and want it to be the
same colour as the form, so it appear invisible unless in is >0 the form
colour is -2147483633 the standard grey colour.

You can use Format... Conditional Formatting to do this in A2002 and
later.

John W. Vinson[MVP]