If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ten checkboxes - how to allow only one to be selected
Hi,
I have a form with ten checkboxes (referring to different age-groups) and need a way to allow the user to select only one of them. User cannot select more than one or none. I cannot use an option group because these checkboxes are all linked to different fields in the same table. They need to remain in different fields because i need to compare the age-groups with another table containing data with these agegroups. is there any solution to this? or maybe a way of redesigning my db? Gianfranco summary of db: the database is made of 2 tables. Table 1 contains cases of influenza with fields for age, GP code, locality, week number, vaccination and agegroups (there is a field for every agegroup and you need to select one only). Table 2 is made up of fields for GP code, week number, and agegroups (again field for every age group and each field contains the number of patients the particular GP has seen in that particlar age group in that particular week) My aim is to calculate incidence of influenza by dividing the number of cases of flu in a particular week (from table 1) by the total number of patients seen in that particular week (from table 2)) |
#2
|
|||
|
|||
Use an OptionGroup with 10 CheckBoxes in the OptionGroup.
Check Access Help on "Option Group". -- HTH Van T. Dinh MVP (Access) wrote in message ups.com... Hi, I have a form with ten checkboxes (referring to different age-groups) and need a way to allow the user to select only one of them. User cannot select more than one or none. I cannot use an option group because these checkboxes are all linked to different fields in the same table. They need to remain in different fields because i need to compare the age-groups with another table containing data with these agegroups. is there any solution to this? or maybe a way of redesigning my db? Gianfranco summary of db: the database is made of 2 tables. Table 1 contains cases of influenza with fields for age, GP code, locality, week number, vaccination and agegroups (there is a field for every agegroup and you need to select one only). Table 2 is made up of fields for GP code, week number, and agegroups (again field for every age group and each field contains the number of patients the particular GP has seen in that particlar age group in that particular week) My aim is to calculate incidence of influenza by dividing the number of cases of flu in a particular week (from table 1) by the total number of patients seen in that particular week (from table 2)) |
#3
|
|||
|
|||
cannot understand what you mean. If I do 10 chk boxes in an option
group, they either all refer to one field or else you get a value from each check box. But then how do i get the value to modify my table from null to yes for the particular age group? gianfranco |
#4
|
|||
|
|||
wrote in message
oups.com... cannot understand what you mean. If I do 10 chk boxes in an option group, they either all refer to one field or else you get a value from each check box. But then how do i get the value to modify my table from null to yes for the particular age group? If only one can be checked then you only need (and should only have) one field. The only time you should create a field per-CheckBox is when more than one can be true at the same time. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
wrote in message
oups.com... cannot understand what you mean. If I do 10 chk boxes in an option group, they either all refer to one field or else you get a value from each check box. But then how do i get the value to modify my table from null to yes for the particular age group? If only one can be checked then you only need (and should only have) one field. The only time you should create a field per-CheckBox is when more than one can be true at the same time. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make form checkboxes from table list | Svein Engebretsen | Using Forms | 1 | October 12th, 2004 07:08 PM |
run macro when worksheet is selected | Carl | Worksheet Functions | 4 | October 3rd, 2004 04:29 PM |
Enhancing the boarder highlighting of a selected cell | Tim Lewis | General Discussion | 1 | September 28th, 2004 11:00 PM |
Selected font changes is being applied to complete document | Bill Dorion | New Users | 2 | August 10th, 2004 06:07 PM |
printing selected rows | Mike | Worksheet Functions | 3 | April 14th, 2004 05:35 PM |