M
myxmaster
Thanks to Fred I have almost resoloved this issue. The only problem is
if withdrawal or transaction is not selected after I enter the amount
a pop up notifies me that I must make the selection, however if I then
go back and select deposit the entry remains a positive number and not
a negative.
If IsNull([TransactionType]) Then
TIA
if withdrawal or transaction is not selected after I enter the amount
a pop up notifies me that I must make the selection, however if I then
go back and select deposit the entry remains a positive number and not
a negative.
If IsNull([TransactionType]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
End If
If Me.[TransactionType] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If
TIA