Values in a new option box

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

Guest

I have a form I have been using and added a new field to the table the form
is bound to. I added the new field to the form using an option box.
However, when i view the form in an "edit" mode (Data Entry = No), the
records which were added prior to adding this new field are "checked", (even
though they are not checked in the table). How can I have the option box
"unchecked" on the form for the previously added records? Thanks
 
There is no such thing as an option box. Do you mean a Check Box or do you
mean an Option Group?
What is the data type of the new field you added?
 
What are the option values of the two check boxes in the option group?

It is unusual to use check boxes in an option group for a Yes/No data type.
One Check Box would be easier because it returns either True (-1) or False
(0).

To use an option group with two check boxes, it automatically assigns an
Option Value of 1 to the first item added and 2 to the next, etc. You will
need to change the Option Value of the check box you want to be Yes (True) to
-1 and the other to 0. Then you will need to set the Default Value of the
Option Group control to whichever you want the default to be or both buttons
will be grey, meaning they have a Null value.

You would be better off to just use a Check box or if you want an option
group, use option buttons.

The wa
 
Back
Top