If Statement, Customer Overpays

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

My Main form is named TimeCards and it has a sub-form on it named
TimeCardPaymentSub
on this sub-form it has a (2) text boxes.
The text box (Balance) shows how much the customers balance is
The text box (OrderAmtA) show the original Invoice amount.
I need the code to display a message box if the customer overpays
The balance would show a negative amount if this happened
The code below does not work?

If (Balance) > (OrderAmtA) Then
MsgBox "Credit Invoice is Needed, Customer Has Overpaid"
End If
 
I need the code to display a message box if the customer overpays
The balance would show a negative amount if this happened
Click to expand...

How about ?

If (Balance) < 0 Then
MsgBox "Credit Invoice is Needed, Customer Has Overpaid"
End If


hth,
 
One more thing, Please
I would like to make a label visible after the message box pop's up.
That is if the same criteria is met.
It is currently set to invisible.
The labels name is Label20
 
Back
Top