Why IIF statement doesn work?

[fixemup27]

I have an Access form set up like a calculater that computes within itself and uses values from the data imported into a named table. Everything works. There are bound and unbound fields in the form that I have working together. However, I am trying to write an if statement and It is not working. The statement is as follows IIF([Net Value]>70,"Acceptable Offer","Unacceptable Offer") The field the IIF statement is in as well as the field it is refering too; however, they are both named so the form can use the name as a "referal". For some reason all the calculations work but when I try to run this IIF statment it enters "unacceptable offer" but it never changes depending on the other fields value. Note: The other cell is tied to another field on the same form as well. What am I missing

 

[sparks80]

Hi,

I'm not entirely sure what is going on without taking a look.

You could try forcing the textbox to update when the value in another control is changed using the afterupdate event for the other control

e.g.

Private Sub OtherControl_AfterUpdate()
    Me!CalculatedTextboxName.Requery
End Sub