My Dumb If

[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

 

[BruceM]

But what? Nothing? Error message? Computer exploded?

How are you running the code?

 

[fredg]

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

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

 

[-Steve]

"Application" is a reserved word, i'd expect you'd have all kinds of problems
using it as you have.

 

[NotGood@All]

Thank you guys for your help. The problem was the use of "Application", I
renamed it and it works, again, thanks!!

 

[BruceM]

Good catch!

"Application" is a reserved word, i'd expect you'd have all kinds of
problems
using it as you have.

 

[Steve Sanford]

For a list of reserved words in Access and SQL, see

http://allenbrowne.com/AppIssueBadWord.html


HTH

 

[Tony Toews [MVP]]

"Application" is a reserved word, i'd expect you'd have all kinds of problems
using it as you have.

Ahh, I missed that.

Tony