A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

form field bounded by checkbox assigns value



 
 
Thread Tools Display Modes
  #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!

  #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!


  #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 -


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.