Validation rule on Boxes

[therock003]

I am experimenting with a new database i just created in Access 2k7 in order to get the grasp of things.

I have created a checkbox field, and i'm trying to set a validation rule, that checks another fields value, and if the value is not the one i set, then the checkbox cannot be applied.

So far this is what i've come up with, but it return invalid syntax

[Field1] Not "Value1" = False

That means that if the value inside Field 1 is anything else but "Value1" then the checkbox cannot be true (checked).

Could anyone please convert this syntax into a working one? Thank You.

 

[Trevor G]

I am experimenting with a new database i just created in Access 2k7 in order to get the grasp of things.

I have created a checkbox field, and i'm trying to set a validation rule, that checks another fields value, and if the value is not the one i set, then the checkbox cannot be applied.

So far this is what i've come up with, but it return invalid syntax

[Field1] Not "Value1" = False

That means that if the value inside Field 1 is anything else but "Value1" then the checkbox cannot be true (checked).

Could anyone please convert this syntax into a working one? Thank You.

If this can be applied to a form you can use the form events and proberbly the best one would be on current (meaning current record)

so the field code would be like this:

If me.FieldName.value ="Value1" then
me.checkboxname=true
else
me.checkboxname=False
End IF

Trevor G