By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Is there a way to have ONE checkbox Off and On?

P: n/a
I have a form where the user is entering information from a phone call.
While usually the caller is calling about another person (who will
be/is the client), very occasionally, a caller is the client.

I have to know this, so I want to put a check box on the form that the
user will "Check" if the caller is also the client.

I can't figure out how to do that. If I use an option group, whatever
is checked can't be "unchecked". I was thinking of examining the value
of the check box after every time it was updated (after update), but
unless there are 2 choices, the box stays permanently "checked'.

Any ideas how to accomplish this? Since it's so rare, I only want to
have the one choice - its default is 0 - "off" and the user turns it
"on" - to 1, when the box is checked, back to 0 when unchecked.

Thanks -
sara

Dec 25 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
sara wrote:
I have a form where the user is entering information from a phone
call. While usually the caller is calling about another person (who
will be/is the client), very occasionally, a caller is the client.

I have to know this, so I want to put a check box on the form that the
user will "Check" if the caller is also the client.

I can't figure out how to do that. If I use an option group, whatever
is checked can't be "unchecked". I was thinking of examining the
value of the check box after every time it was updated (after
update), but unless there are 2 choices, the box stays permanently
"checked'.

Any ideas how to accomplish this? Since it's so rare, I only want to
have the one choice - its default is 0 - "off" and the user turns it
"on" - to 1, when the box is checked, back to 0 when unchecked.

Thanks -
sara
A CheckBox bound directly to a Yes/No field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 25 '06 #2

P: n/a
How do you do that? I see the frame can be bound, but how do you bind
the checkbox? If the checkbox is chosen, I will update another field
with the value "4" and know to write records to various tables, based
on that.

Will a yes/no field still work? Where is the field stored?

thanks
Sara

Rick Brandt wrote:
sara wrote:
I have a form where the user is entering information from a phone
call. While usually the caller is calling about another person (who
will be/is the client), very occasionally, a caller is the client.

I have to know this, so I want to put a check box on the form that the
user will "Check" if the caller is also the client.

I can't figure out how to do that. If I use an option group, whatever
is checked can't be "unchecked". I was thinking of examining the
value of the check box after every time it was updated (after
update), but unless there are 2 choices, the box stays permanently
"checked'.

Any ideas how to accomplish this? Since it's so rare, I only want to
have the one choice - its default is 0 - "off" and the user turns it
"on" - to 1, when the box is checked, back to 0 when unchecked.

Thanks -
sara

A CheckBox bound directly to a Yes/No field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 25 '06 #3

P: n/a
sara wrote:
How do you do that? I see the frame can be bound, but how do you bind
the checkbox? If the checkbox is chosen, I will update another field
with the value "4" and know to write records to various tables, based
on that.

Will a yes/no field still work? Where is the field stored?
The forest you are looking for is over behind those trees :-)

OptionGroup frames are for RadioButtons. CheckBoxes reside directly on the
form. Once you move the CheckBox outside the frame you can bind it directly to
a YesNo field just like you can bind a TextBox or ComboBox, etc..

When the CheckBox is "checked" that will store True (-1) in the underlying
field. When "unchecked" it will store False (0).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 25 '06 #4

P: n/a
Can you tell I'm new?

Well, I get what you're saying about the checkbox, but I don't have a
yes/no field. How can I bind a box to a field I don't have? I'm still
missing something here....

Sara
Rick Brandt wrote:
sara wrote:
How do you do that? I see the frame can be bound, but how do you bind
the checkbox? If the checkbox is chosen, I will update another field
with the value "4" and know to write records to various tables, based
on that.

Will a yes/no field still work? Where is the field stored?

The forest you are looking for is over behind those trees :-)

OptionGroup frames are for RadioButtons. CheckBoxes reside directly on the
form. Once you move the CheckBox outside the frame you can bind it directly to
a YesNo field just like you can bind a TextBox or ComboBox, etc..

When the CheckBox is "checked" that will store True (-1) in the underlying
field. When "unchecked" it will store False (0).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 25 '06 #5

P: n/a
sara wrote:
Can you tell I'm new?

Well, I get what you're saying about the checkbox, but I don't have a
yes/no field. How can I bind a box to a field I don't have? I'm still
missing something here....
You ADD a Yes/No field to your table and then use the CheckBox on your form to
edit that field.

If "IsCallerAClient" is a piece of data you want to capture then you must have a
field in the table to store it in.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 25 '06 #6

P: n/a
I think I've got it!!

I decided to just try without the field; and it's doing what I wanted.
I had to use the other "hint" you gave me - the value is -1! I think I
am all set. Thanks so much.

Sara
Rick Brandt wrote:
sara wrote:
How do you do that? I see the frame can be bound, but how do you bind
the checkbox? If the checkbox is chosen, I will update another field
with the value "4" and know to write records to various tables, based
on that.

Will a yes/no field still work? Where is the field stored?

The forest you are looking for is over behind those trees :-)

OptionGroup frames are for RadioButtons. CheckBoxes reside directly on the
form. Once you move the CheckBox outside the frame you can bind it directly to
a YesNo field just like you can bind a TextBox or ComboBox, etc..

When the CheckBox is "checked" that will store True (-1) in the underlying
field. When "unchecked" it will store False (0).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 25 '06 #7

P: n/a
You have to create a Yes/No field in your underlying table. If your form is
based on a query, be sure to go into the Design Grid for the query and
include your new field there as well, to make it available to your form.

I'd actually just delete the check box you already have, do the above listed
things, then goto the Fields box in Design View of your form and move the new
field onto your form.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Dec 25 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.