Question re yes/no fields and checkboxes

[Guest]

I want to add the option of yes or no on a form but I want to have two
checkboxes. One for Yes and one for No. Should I use a yes/no field in my
table and then create an option group in my form with a checkbox for yes and
a checkbox for no. I am not sure if the field in the table should be a yes/no
field. For example I would have a question: "Has patient had previous
treatment " and there would be checkbox for Yes and a checkbox for No. What
would be the best way to accomplish this. I am using Access 2003

Thanks in advance for any help.

Best regards,

Dee

 

[John Vinson]

I want to add the option of yes or no on a form but I want to have two
checkboxes. One for Yes and one for No. Should I use a yes/no field in my
table and then create an option group in my form with a checkbox for yes and
a checkbox for no. I am not sure if the field in the table should be a yes/no
field. For example I would have a question: "Has patient had previous
treatment " and there would be checkbox for Yes and a checkbox for No. What
would be the best way to accomplish this. I am using Access 2003

Thanks in advance for any help.

Best regards,

Dee

An Option Group control bound to the yes/no field will work. The value
of the Yes checkbox should be -1, the No checkbox 0. I believe the
toolbox option group wizard will do this for you.

John W. Vinson[MVP]