Combining two boolean values

[John_B]

Hey guys,



Here's my problem. I basically have two yes/no fields in an access table. I want field one to have the value yes if field two has value no, and the other way arround.

I had a look at the Boolean operators, but im not sure where to go from there.

Can anyone help me out ? I suppose theres a simple solution.

Best Regards,

John

[dodo47]

Hi
try in the after update event of each boolean filed:

Private Sub MyYesNo1_AfterUpdate()
Me.MyYesNo1 = True = Me.MyYesNo2 = False
End Sub

Private Sub MyYesNo2_AfterUpdate()
Me.MyYesNo1 = True = Me.MyYesNo2 = False
End Sub

or something else like it

regards

[John_B]

Hi Dodo47

Thanks for you help so far. Is the code you provided only applicable in a form or can i also apply it directly to the yes/no fields?

Also im not quite sure where to find the "after update event of each boolean filled".

Thanks again in advance!

[dodo47]

Apologise...
i have 2003.... and don't know if 2010 has same structure, anyway

In forms structure:
right click the yes/no field > property > events

I don't think that you can this in costruction table

regards

[orange]

Just curious, why you need 2 such fields and a condition that if one is Yes then the other is No.
If you have one field that has only 2 possible values, seems you could determine the values by reading that one field.

Anyway, just a thought.

Perhaps you could describe the 2 fields and what you are trying to do.

[John_B]

I basically have a couple of tables. One of them is called "Students". In that table i have two fields wich are called "present" and "absent".

The students are physically carrying passes arround that grants them entry to the school if a couple of conditions are true. One of them would be that a student can only access the school if the checkbox "absent" is checked, and only leave the school if the checkbox "present" is checked.

I might be able to use one boolean tho. How would i configure that?

[orange]

What if you had 1 field called CurrentStatus, and it could have 2 values
1- Present
2 -Absent
or CheckedIn and CheckedOut
or Here and Away

Basically any 2 consistent values that make sense to you.

Often in a boolean sense, you have a "switch" and it sets the current value to the opposite value.

For example,

'switch the value of setting
...
Setting = NOT Setting
...

so when this code is executed, the value of Setting will change.