yes/no field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick code 4
help with a query 3
yes/no questionnaire 1
Checkbox to activate textbox input 11
Avoid Dups 2
Yes/No Fields, a Query, and a Macro 5
Yes/No fields 2
Subform with selected item 1

Back
Top