How to ensure that on a continous form of 12 row only 1 tick box is checked??

[Robert K]

Hi there,

I have listed 12 month on a continous form, where as I flag the current

month with a tick box.
To ensure at only 1 tick box is check not more or all I would want to
validate and ensure that at all times one tock box is checked!

any ideas??

so far I used dsum(xx,xx) in reference with the before update event of
the check box. This works as a once of. If I click it again it allows
me to select 2 check boxes. ???

Regards
Robert K

[Jamey]

make sure all your check boxes are part of the same Option Group and
you should only be able to select a single value for them. you can set
that value either through code or simply by selecting them and you'll
only be able to select one value for the overall frame in that case.
you can also set them by using the Default Value.

[Robert K]

Jamey,

I find what you say confusing.
How can you set a frame on a contious form, whereas only one check box
represents the value of eg: column A??

It just doesn't make sence!
Thanks for your comments.

Regards

Robert K

Jamey wrote:

make sure all your check boxes are part of the same Option Group and
you should only be able to select a single value for them. you can set that value either through code or simply by selecting them and you'll
only be able to select one value for the overall frame in that case.
you can also set them by using the Default Value.

[Bob Quintal]

"Robert K" <Re*********@amp.com.au> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

Jamey,

I find what you say confusing.
How can you set a frame on a contious form, whereas only one
check box represents the value of eg: column A??

It just doesn't make sence!
Thanks for your comments.

Regards

Robert K

Jamey wrote:

make sure all your check boxes are part of the same Option
Group and you should only be able to select a single value
for them. you can

set

that value either through code or simply by selecting them
and you'll only be able to select one value for the overall
frame in that case. you can also set them by using the
Default Value.

First of all, I canot imagine a valid databsae design which would
require your 12 child records. One record with a number from 1 to
12 would be adequate for any design.
--
Bob Quintal

PA is y I've altered my email address.