H hziggy New member Local time Today, 20:44 Joined Feb 4, 2003 Messages 6 Mar 4, 2003 #1 I have a field amount that is currency. I also have a combo box with the coice of To or From. If the user selects "From" I need the amount the user enters to be negative. Sounds so simple??????????
I have a field amount that is currency. I also have a combo box with the coice of To or From. If the user selects "From" I need the amount the user enters to be negative. Sounds so simple??????????
W WayneRyan AWF VIP Local time Today, 20:44 Joined Nov 19, 2002 Messages 7,120 Mar 4, 2003 #3 hziggy, Put this in the AfterUpdate event of your amount field: If Me.cboToFrom = "From" And Me.Amount < 0 Then Me.Amount = Me.Amount * -1 End If You'll have to change the names ... Wayne
hziggy, Put this in the AfterUpdate event of your amount field: If Me.cboToFrom = "From" And Me.Amount < 0 Then Me.Amount = Me.Amount * -1 End If You'll have to change the names ... Wayne
