473,322 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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

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
7 1674
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Fabri | last post by:
How can I, on button click, to select ONLY the following 4 checkbox? I would like to do this without a for loop through form.lenght because this is only an example and I have to apply this script...
0
by: mike | last post by:
Hi there: I've read an excellent "how to"-article by Microsoft (no. 306227) - partly cited cited at the end of this email). I have implemented the code related to the part "How to Add a...
5
by: DotNetJunkies User | last post by:
1. i want to populate checkboxlist using javascript only at client side ....how can i do this..by populate word i mean that checkboxes should be checked or unchecked on some condition basis.......
10
by: rn5a | last post by:
All the rows in a DataGrid, including the Header, are accompanied with a CheckBox. I want that when the CheckBox in the Header is checked, then all the CheckBoxes should automatically get checked....
0
by: cyberdawg999 | last post by:
Greetings all in ASP land I have overcome one obstacle that took me 2 weeks to overcome and I did it!!!!! I am so elated!! thank you to all who invested their time and energy towards helping me...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.