Conditional Checkbox

  • Thread starter Thread starter FpwL1399
  • Start date Start date
F

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.
 
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.
Click to expand...

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]
 
Back
Top