easy IIF statement not working

[siculster]

I have a tick box called [weekend_full] which when checked should insert 150 into the field [Fee amount]. I have came up with the following code:

=IIf([weekend_full]=True,[Fee amount]=150,[Fee amount]=0)

This obviously doesn't work. What is the correct code & where should I insert it?

Thanks

 

[Newman]

Does your Weekend_full field has 0 as default value?
Else, the field is Null and not 0 as long as you don't click in it.
And a Null value wouldn't pass the IIf test.

Else, more details needed to understand your problem correctly.

 

[Peter D]

Where did you put that code?

 

[Mile-O]

In the ControlSource of your FeeAmount textbox:

=IIf([weekend_full]=True, 150, 0)