check box simple question

[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?

 

[Keith Wilby]

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?

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

Keith.
www.keithwilby.co.uk

 

[Ron2006]

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