Check box help

[mraccess]

I have two form that each have a check box in them.

I want to have them looking at each other to determine there state.

Exaplme, check box one true when check box two is false

 

[Mackster66]

Are your check boxes bound to a record source? In other words, are they
based on a yes/no field in your table?

Are the check boxes on separate forms or the same form?

One possibility is to place the check boxes in an option group. That way,
when one is checked, the other will be automatically unchecked and vice-versa.

If they are on separate forms, then you will most likely need to use VBA to
create a rule.

 

[mraccess]

Yip they are bound, and on separate forms

Are your check boxes bound to a record source? In other words, are they
based on a yes/no field in your table?

Are the check boxes on separate forms or the same form?

One possibility is to place the check boxes in an option group. That way,
when one is checked, the other will be automatically unchecked and vice-versa.

If they are on separate forms, then you will most likely need to use VBA to
create a rule.

 

[Mackster66]

What record sources are they bound to?

Are these record sources in the same table or different tables?

Which version of Access are you using?