CheckBox Selection

[srpatel]

Hi,

Am a beginner with access development and require some help.

I have a form called 'frmSelectCode' which has Two Text Boxes and a
Checkbox. The text boxes are bound to the values from Table
'tblAllCodes'. In total there are about 66 fields.

On the main form, there is a Cmd Button that has an onClick Event,
which calls frmSelectCode. This opens up and a user is presented with
all the fields and checkboxes besides the field to choose from.

At present users can select as many check boxes as they want. I would
like this to be limited to have only one checkbox selected at one time.


Could someone point to the right direction.

Thanks
Shreekant

 

[TC]

Put them in an "option group".

You should also change them to option buttons. The normal rule is, the
user /should/ be able to select more than one checkbox, but he should
/not/ be able to select more than one option group. Everyone should
follow that standard.

Look up the various terms in F1 Help, there should be some info. there.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[srpatel]

If put them in an options group I will end up having 66 options.

Surely there must be some VBA code that enable one check box selected
at a time.

 

[TC]

Huh?

50 checkboxes *NOT* in an option group:

1 [ ] 2 [ ] 3 [ ] ... 50 [ ]

50 checkboxes *IN* an option group:

1 [ ] 2 [ ] 3 [ ] ... 50 [ ]

Total change to number of checkboxes:

zero

So why make that change?

In the first case the user can click one, two or all of them;
in the second case he can only click one - Access will not
let him click more than one at the same time.

Further change that you should make:

Change the checkboxes to option buttons, to follow
the standard guidelines for a Windows user interface.

Did you look up option groups in Access help?

HTH,
TC (MVP Access)
http://tc2.atspace.com