two text box

[fule12]

Hi to All!!!!
I think i have one easy question
I have two field on form,first is currency and i second mast come one letter (D or C) depend of currency amount.
If amount is positive(+) in another filed nead to show C if amount come to negative (-) nead to show D.
So i nead code for this.
Thanks Fule

 

[SgtJarrow]

If Me![CurrencyField]>=0 Then
Me![LetterField] = "C"
Else
Me![Letterfield] = "D"
End If


Should do the trick.
Good Luck! %-)

There is no I in team.

Robert L. Johnson III, A+, Network+
robert.l.johnson.iii@citi.com