By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,574 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.


Nov 13 '05 #3

P: n/a
"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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.