Making controls on Form update automatically

[mmcginley]

I have a couple of drop down menus on a form i have designed which have values which are dependent on another drop down.

So, for example, when i select USA in country, the US$, appears in my currency box but i have to select US$ from the drop down when i want it to appear automatically.

Any ideas on how to do this?

Cheers

Also, i have a calcualtion attached to a text box:

[Text87] = (1 / [List93]) * [Combo85]

However, the calculation will not be performed, even on click, until [List93] has been clicked on. [List93] is a constant value and is a hidden field so how can i make access perform the calculation without clickin [List93]

Many thanks in advance

Cheers again

 

[mmcginley]

No suggestions then?

 

[MStCyr]

In the After Update event, try Me.refresh