check box simple question

  • Thread starter Thread starter kyle12345
  • Start date Start date
K

kyle12345

I have added a check box to a form and assigned the appropriate control
source. How do I get the check box to update the appropriate field? All I
need is it to change the field to -1 or yes or true if the box is check and 0
or no or false if it is not checked?
 
kyle12345 said:
I have added a check box to a form and assigned the appropriate control
source. How do I get the check box to update the appropriate field? All
I
need is it to change the field to -1 or yes or true if the box is check
and 0
or no or false if it is not checked?
Click to expand...

If the bound field is Boolean then it should all happen automagically.

Keith.
www.keithwilby.co.uk
 
If the field is a new field that I have added to the table after its
inception/creation and use, then I always do the following:


1) I do not like to use three state value for boolean fields, so when
I create the field

A - define the field with a default value of true or false as required
by my design and planned use of the field

B - immediately create and run an update query to set the field to the
default value for all records that already exist in the table.

Ron
 
Back
Top