View Single Post
  #2  
Old April 16th, 2008, 06:37 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default form field bounded by checkbox assigns value

You are mixing a lot of stuff that does not mix.
A checkbox is for True/False or Yes/No etc. The information is stored as a
-1 or 0 (zero). The field bound to the checkbox would be a lon integer but
would not work using a the default + 8.
It sounds like you want to use one field for multiple checkboxes. If this
is correct then what you need is an Options Group. An Options Group has a
bunch of buttons, checkboxes, or some such and are bound to a single field.
Based on which is selected is the number stored in the field. The buttons
are a part of the group and are in a Frame.
If this is what you want then use the toolbox to create an Options Group and
bind to your field.

--
KARL DEWEY
Build a little - Test a little


"mcheng" wrote:

A long integer field is bounded by an associated check box. Let's say
the integer field is named ID and the checkbox is named CB1.

Currently, when CB is checked, the value of -1 is assigned to ID.

I'm trying to use this current (Default?) value of -1 in an equation
to come up with the actual ID number I want corresponding with CB1
(let's say it should be 7). So the default + 8 would get the right
ID. However, I am missing something... the Expression Builder is not
affecting the form display. Any thoughts on why this is the case?

The plan is when I add a new checkbox, CB2, I'd be able to build the
expression to correspond with the right ID for the associated
checkboxes.

Thanks for the help!