Calculated Checkbox values

Put the following code in the Current event of your form:
If Me!NameOfFirstField = Me!NameOfSecondField Then
Me!NameOfCheckBox = True
Else
Me!NameOfCheckBox = False
End If

Steve



"Wookawsh" <Wookawsh DeleteThis @discussions.microsoft.com> wrote in message
news:E7EB91C1-F0A0-4F17-847D-2851423868CC@microsoft.com...
> Im trying to set a checkbox value to a "true" or "checked" state when
> another
> field is equal to, or greater than another value in another field.
> What would be the best way to do this?
> (I guess I cant apply conditional formatting to checkboxes?)
>
> Thanks for the help.
> --
> Lukasz

Also you will have to add that very same code to the after update
event of the two fields used in the logic.

If you do not do this then when you change either of them the checkbox
will NOT be changed until you get off of and return to the record.

Ron

Good point, Ron, and in the Current event, probably
--
Dave Hargis, Microsoft Access MVP


"Ron2006" wrote:

> Also you will have to add that very same code to the after update
> event of the two fields used in the logic.
>
> If you do not do this then when you change either of them the checkbox
> will NOT be changed until you get off of and return to the record.
>
> Ron
>

Yes

--
Lukasz


"Ron2006" wrote:

> Yes
> Thank You for the prompt responses, its really impressive. I just need a little more help. My coding experience is limited.

First, I should have been more clear. This is the exact statment that I need
to execute

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?))

Ive found the "after update" in the code builder section, but I couldnt find
the "current event" field"

Once again your help and quick responses are appreciated. Thanks.

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