yes/no field

C

Carol Shu

I have a DB for customers address, i like to create a yes/no field neme "out
of the state" , that will automaticly check "yes" when customer is from out
side of the Missouri state, if customer is from Missouri, it will uncheck,
could you please help me this...
 
R

Rick Brandt

Carol said:
I have a DB for customers address, i like to create a yes/no field
neme "out of the state" , that will automaticly check "yes" when
customer is from out side of the Missouri state, if customer is from
Missouri, it will uncheck, could you please help me this...
Click to expand...

You don't need to store this in the table. Just add a CheckBox to your forms
and reports with a ControlSource of..

=([state]<>"Missouri")
 
Top