Jessica
Looking back to your original post, I see you were having a problem with the checkboxes all changing instead of just the one for each row. The check box must have a control source of a field in your table. If it is unbound (not bound to a field in your table) it will act just as you see now.
I think you are confusing checkbox with radio button. A standard option group has at least 2 buttons.
A checkbox has 2 possible values: checked or unchecked. That translates to true/false, Yes/No, On/Off.
An option group with 2 buttons is the same thing but it can also be null (neither button is clicked). The two values can be any integer.
The option group should have one field as its ControlSource just like a check box. I hope you do not have two fields in your table: one for Yes and one for No. That is not the way to do it, but the way your posts read I'm beginning to suspect that.
This it how a table should be structured:
CustomerID - Primary key (autonumber)
ComanyName - text
blah
blah
Active - Yes/No
Active if Yes indicates the customer is active. No would indicate it's not active.
Does that help any?
-Bill
---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
Thanks Bill, I have an option box with the two radio buttons for Yes and No. How do I use an option box without the check boxes?
Sorry, I have a lot to learn about Access.
Jessica
On Wednesday, March 25, 2015 2:42 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica
Don't you just love pointy-hair bosses? Use an option group with no check boxes. You could fake check boxes but it would require a lot of coding for no good reason.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
Good Afternoon all!
I'm trying to add yes/no checkboxes to a form. The checkboxes are actually on a subform which is continuous allowing the user to enter multiple selections on one form. I have no problem with just one checkbox for Yes, however, the bosses want Yes and No checkboxes so the user will have to check one or the other.
I tried to use an option group which works as far as storing data, however, if the user checks Yes on the first entry and then checks No on the second entry the first checkbox will switch to No. This doesn't appear to change the data being stored from the user's entries, just the checkbox appearance on the form. I'm afraid this will cause a lot of confusion.
What am I doing wrong?
Jessica
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar