Using 2 combo boxes to fill a text box

[Fi]

Hi
I am trying to use the choices made in two combo boxes, one to choose an investment fund and one for the investment date the choices made would determine which interest rate should be used and I would like this value to appear in the text box,
Can anyone help ????
many thanks

 

[Rich]

Which text box? If you've select what you want in the combo box then the values should be displayed in the combo. What exactly are you trying to achieve?

 

[Geoff Codd]

what tables do you have, do you have one for investment fund Types and One for Invset ment fund interest rates and applicable date that they became effective

 

[Fi]

sorry that was a bit fuzzy, on the form I would like to be able to choose the fund and then the date of investment from the 2 combo boxes (already set up and working)once these choices have been made I would like the interest rate applicable for this fund on this date to be entered in the interest rate box (i called it text box previously).
I have tried putting all the info into one table but there are 30 funds, they span 10 years and each has one investment date a month with a relevant interest rate, on my form i set up a combo box based on this then in AfterUpdate I autofilled the interest rate, which although this gives me the info I am after each fund needed to be repeated 120 times on the table to cover all the interest rates.
so basically what I want the interest rate box to do is look at the fund and date chosen from the combo boxes and show the interest rate applicable.
Hope this makes more sense

thanks for your replies

 

[Geoff Codd]

I've just sent you an example database with an example of how to do it