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

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!