Calculation won't work

[mmcginley]

Ok, i have a problem and i can think of no reason why what i'm doing shouldn't work.

I have a form with a number of combo boxes like so.

Combo1: RSP
Combo2: Currency
Combo3: GBP Exchange Rate
Combo4: Euro Exchange Rate
Combo5: RSP (In Euros)

I type in the RSP in the first box, i then select currency (only one currency will be availabe based on an earlier choice of country), select exchange rate in GBP and Euros and then Combo 5 has a simple calculation to perform.

[Combo5] = [Combo4] * [Combo1]

This will convert the original value RSP (which is in local currency) to the RSP in Euros. Ideally this calculation would happen automatically and fill Combo5 but it won't work. I can't even get this to happen as an on click event.

I can't understand why this won't work although i'm sure one of you will show what a simple thing it is. I just can't seem to get my head around it.

Many thanks in advance

Martyn

 

[Oldsoftboss]

Are your combo boxes bound to the column of data you are wanting to multiply?

 

[mmcginley]

The bound field on the properties column has a one in it. I'm almost completely new to access, what does 'bound' actually mean?