Conditional Checkbox

[FpwL1399]

Hi, I would like to set a checkbox to check itself only if an entry is
<30. Is this possible?

I'm not very good with code, and I've tried using
=iif([Particles]<30,True,False) in the condition statement like another
posting said, but that doesn't seem to effect anything.

 

[John Vinson]

Hi, I would like to set a checkbox to check itself only if an entry is
<30. Is this possible?

I'm not very good with code, and I've tried using
=iif([Particles]<30,True,False) in the condition statement like another
posting said, but that doesn't seem to effect anything.

Don't put it in the Criteria line - put the expression in a vacant
Field cell in the query grid.

The checkbox yes/no field should *simply not exist* in your table.
Just calculate its value in the Query as needed; don't store it.

John W. Vinson[MVP]