Expression

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression 1
Is this possible 4
Macro to Select text from a point given to a specific word 2
Expression subtracts double 4
Expression help continued 1
VBA Export to PDF 0
Help with DSUM 3
This is illogical... 4

Top