need help

M

mhmaid

hello
i want to use if function to fill in one field.i.e
if Currencycode=USD then Roe =1
i want the system to automaticaly show "1" in the Roe field in case i choose
the currency e.g.USD. is it possible
 
T

TomU

There are two ways to do this. The easiest is to use IIF. In the Control
Source for the Roe text control, put something like:

= IIF ([CurrencyCode] = "USD", 1, 99)

As this is written, if CurrencyCode, which I assume is a string value, is
"USD" then 1 shows in the Roe field. Otherwise 99 shows in the Roe field.
 
Top