Tick Box value

[Bob Line]

Hi I have the following problem, I want to use a tick box to up date the
next field if the box is ticked.
I have used the following code but it will only work if I use a text box in
stead of the tick box and type in the word "YES"
If Me.FPI= "YES" then
Me.FPICost ="5"
End If

The tick box is set to Yes/No

Any idea's what I am doing wrong?

Thanks Bob

 

[NH]

Try using

If Me!FPI = True then....

Regards

Nick

 

[Bob Line]

Sorted, thanks Bob

Try using

If Me!FPI = True then....

Regards

Nick