View Single Post
  #3  
Old April 16th, 2008, 07:04 PM posted to microsoft.public.access.forms
mcheng[_2_]
external usenet poster
 
Posts: 4
Default form field bounded by checkbox assigns value

That's exactly what i needed. Thanks!

On Apr 16, 1:37*pm, KARL DEWEY
wrote:
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!- Hide quoted text -


- Show quoted text -