My Dumb If

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have 2 text boxes, Application, and ApplicationMoney, if Application = "No
Application Fee" I want ApplicationMoney to = 0, if Application =
"Apprlication Fee" I want AmmplicationMoney to = 25. I used this code but...

If Me.Application = "No Application Fee" Then
Me.ApplicationMoney = 25
Else: Me.ApplicationMoney = 0
End If
 
I have 2 text boxes, Application, and ApplicationMoney, if Application = "No
Application Fee" I want ApplicationMoney to = 0, if Application =
"Apprlication Fee" I want AmmplicationMoney to = 25. I used this code but...

If Me.Application = "No Application Fee" Then
Me.ApplicationMoney = 25
Else: Me.ApplicationMoney = 0
End If
Click to expand...

But... what?

It seems to me that you have reversed the logic of your code from the
stated logic of your text.
Where have you placed this code?\

Try the [Application] control's AfterUpdate event:

If Me.[Application] = "No Application Fee" Then
Me.ApplicationMoney = 0
Else
Me.ApplicationMoney = 25
End If
 
"Application" is a reserved word, i'd expect you'd have all kinds of problems
using it as you have.
 
Thank you guys for your help. The problem was the use of "Application", I
renamed it and it works, again, thanks!!
 
Back
Top