473,323 Members | 1,574 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,323 software developers and data experts.

How do you use multiple checkboxes in Forms to affect one value in a table?

54
I have a table (Contacts) that has a Yes/No data type field named Active. I also have a form which has an option group containing 2 check boxes.

What I am trying to do is make it so that the user can select either the Active checkbox or the Not Active checkbox in the form which should then update the field (Active) in the table (i.e. if the user selects Active (in the form) the Active field in the table should show this and if the user selects Not Active (in the form) the Active field in the table should show this). However I only seem to be able to get the checkboxes to give the option value 1 or 2 and the table will only accept True or False or Yes or No therefore meaning that the table is not being updated (I realised this instantly when I clicked a check box and no tick appeared in it - this was proven when I opened the table. Do I need to use VBA code and if so how would I go about doing this? I'm sorry if this sounds vague

Help would be greatly appreciated. Thanks!
Sep 15 '09 #1

✓ answered by NeoPa

You need to set the .OptionValue values of your CheckBoxes to True & False in the design. The Option Group can then default to either (.DefaultValue property).

Let us know how you get on.

4 3496
NeoPa
32,556 Expert Mod 16PB
You need to set the .OptionValue values of your CheckBoxes to True & False in the design. The Option Group can then default to either (.DefaultValue property).

Let us know how you get on.
Sep 15 '09 #2
OldBirdman
675 512MB
You could also eliminate the Options Group, and have a single checkbox bound to your table. Then the checkbox might be labeled "Active if Checked".
Note: Most Windows applications use Radio Buttons in this type of use, to show that one, and only one, can be true, the other(s) must be false. Checkboxes are usually used where some, none, or all the choices presented my be true (checked).
Sep 16 '09 #3
g diddy
54
Thanks for the help i've fixed it now
Sep 16 '09 #4
NeoPa
32,556 Expert Mod 16PB
Very pleased to hear that, but could I draw your attention to OldBirdmans comments. They are well worth taking note of. Users may indeed be confused by your current (non-standard) layout.
Sep 16 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: jason | last post by:
How does one loop through the contents of a form complicated by dynamic construction of checkboxes which are assigned a 'model' and 'listingID' to the NAME field on the fly in this syntax:...
1
by: PT | last post by:
I got a problem. And thats..... First of all, I got these three tables. ------------------- ------------------ ---------------------- tblPerson tblPersonSoftware ...
3
by: claudel | last post by:
Hi I have a newb PHP/Javascript question regarding checkbox processing I'm not sure which area it falls into so I crossposted to comp.lang.php and comp.lang.javascript. I'm trying to...
4
by: moondaddy | last post by:
There are different times when I will have a group of checkboxes and need to force only one to be checked at a time. I would also like to do this client side and not require a postback. These...
4
by: jedimasta | last post by:
Good evening all, I'm a relatively new to javascript, but I've been working with ColdFusion and PHP for years so I'm not necessarily ignorant, just stuck and frustrated. Using ColdFusion I'm...
7
by: magmike | last post by:
I currently have a button once clicked, invokes the following: If Address_Select = -1 Then Forms!ProspectForm!Address = End If However, there are 11 other fields in the subform that i'd like...
0
by: TechnoAtif | last post by:
<?php include "dbconnect.php"; include "commonFunc.php"; ?> <!----------------------------------> <table width="80%" border="1" cellpadding="2" cellspacing="0"> <tr > <td...
11
by: TechnoAtif | last post by:
INSERT AND UPDATE MULTIPLE CHECKBOX DATA USING PHPMYSQL OR JAVASCRIPT Hi All I want to check the multiple checkboxes update them after revisiting that page. I am taking the name as...
6
by: ahilar12 | last post by:
<html> <head> <script type="text/javascript"> function SetAllCheckBoxes(FormName, FieldName, CheckValue) { if(!document.forms) return; var objCheckBoxes = document.forms.elements;...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.