 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / December 2006Is 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 > I have a form where the user is entering information from a phone > call. While usually the caller is calling about another person (who [quoted text clipped - 15 lines] > Thanks - > sara A CheckBox bound directly to a Yes/No field.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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 > > I have a form where the user is entering information from a phone > > call. While usually the caller is calling about another person (who [quoted text clipped - 22 lines] > Email (as appropriate) to... > RBrandt at Hunter dot com > 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). SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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 > > 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 [quoted text clipped - 16 lines] > Email (as appropriate) to... > RBrandt at Hunter dot com > 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. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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. SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 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 > > 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 [quoted text clipped - 16 lines] > Email (as appropriate) to... > RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.