Unbound Check Box

[mixedguy]

Help. I've created an Unbound Checkbox that I would liked to be checked when another textbox within the report has a value greater then 30.

For example:

IIf([Text101]>30, True,False)

This is what I've tried putting in the control source of the unbound check box and it gives me errors.

Thanks in advance!

 

[Sohaila Taravati]

Do it in the query and call and then put in on your form:

NewTextBox: IIf([Text101]>30, True,False)