Currency Lookup

[JeffreyDavid]

I have my customer table and one of the fields is the Country. I have a text box (txtCurrency) on my form that I want to display the type of currency that country uses. If country is Canada then currency is CDN, if anything else currency is US. I pretty sure I'd use an If Else statement but not sure about the code.
Any ideas?

 

[spacepro]

I am assuming you have a textbox called txtCountry to display the country or combo (cboCountry).
If you are using a combo:

If me.cboCountry = "Canada" Then
me.txtCurrency = "CDN"
Else
me.txtcurrency = "US"
End If

If you are using a textbox for the country then :

If me.txtCountry = "Canada" Then
me.txtCurrency = "CDN"
Else
me.txtcurrency = "US"
End If

HTH

Andy