Calculated Checkbox values

Thanks for that. If you wouldnt mind commenting on the other part of my
question. I tried to make it more specific as I dont think I was clear
enought before. Here is the expression Im trying to execute on my form:

When Field 1 >= 12, then Checkbox 1 = Yes/Checked
(also, will having this violate any database rules, as the checkbox value is
in one of my tables (i.e. is this like a calculated value?))

Thanks for all your help.
--
Lukasz


"Ron2006" wrote:

> The OnCurrent event is an event for the form NOT a field.
>
> It is the first one on the event tab on the properties for the form
> itself.
>
> Ron
>

If Checkbox1 is always True when Field1 is greater than or equal to 12 and
always false otherwise, then this should be a calculated field. And you
should not store it in the table at all.

On a form or in a report you can add a checkbox control and set it's control
source to
= [Field1]>=12


In a query you can calculate the value with the same expression (minus the
first equals sign).


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Wookawsh wrote:
> Thanks for that. If you wouldnt mind commenting on the other part of my
> question. I tried to make it more specific as I dont think I was clear
> enought before. Here is the expression Im trying to execute on my form:
>
> When Field 1 >= 12, then Checkbox 1 = Yes/Checked
> (also, will having this violate any database rules, as the checkbox value is
> in one of my tables (i.e. is this like a calculated value?))
>
> Thanks for all your help.