expressions....

V

vassilis

hello there
i have three fields (yes/no)...i was wondering if there is a way, the one of
them turns yes when the other two are yes, and the opposite. i was looking on
the expression builder in microsoft but i didnt found something so far...
thanks
 
V

vassilis

im very sorry for asking u again but i didnt express my thought very well
before my english r terrible ...

im was thinking something like that:
check1 check2 check 3
no no --->yes
no yes --->yes
yes no ---->yes
yes yes --->no

if u can help me with this ...thanks again
 
P

Pat Hartman\(MVP\)

When you have a mutually exclusive choice, you should store a single field
rather than three separate fields and you should use an option group to
display the choices except when there are a lot of them. In that case, you
would use a combo.
 
V

vassilis

yes exactly that....the only time the last <check button> turns <off> is
when all the other are <on> . in any other situation the last button is
<on>...
now im making experiments with 3 button but in my db i will use more...
if u can help me that would be great....


Ο χÏήστης "RobFMS" έγγÏαψε:
 
V

vassilis

the many buttons correspond to partial works and the last one for
pendency...so the last one has to be uncheck only all the others are
checked...i didnt find any other way to do this..

Ο χÏήστης "Pat Hartman(MVP)" έγγÏαψε:
 
V

vassilis

the third section with the< public function..>start , where is it fit ? :)

i have no idea about that vb code but i guess, bulding one for six or
seven button must be chaos..
thanks for your spend time!!

Ο χÏήστης "RobFMS" έγγÏαψε:
 
Top