ten checkboxes - how to allow only one to be selected

[gianfranco.spiteri]

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))

 

[Van T. Dinh]

Use an OptionGroup with 10 CheckBoxes in the OptionGroup.

Check Access Help on "Option Group".

 

[gianfranco.spiteri]

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

 

[Rick Brandt]

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.