Picking only one Checkbox

[BrianFawcett]

I am creating a new order form and there are areas on the form where the user needs to check a box (Order Type for example) but I want the user to only be able to choose one. How do I create this?

 

[boblarson]

Can you post a screenshot of the form? It would be by following these instructions:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[BrianFawcett]

Bob, I beleive that you posted the incorrect link. Here is my form. There are I think 7 groups of checkboxes that should have only one choice picked.

 

[boblarson]

Bob, I beleive that you posted the incorrect link.

No, it is the correct link. Why do you think it was incorrect? The link shows you how to upload a screenshot to this forum and then how to display it inline in the forum post instead of just as a link.

Here is my form. There are I think 7 groups of checkboxes that should have only one choice picked.

Not seeing anything. Nothing is attached.

 

[BrianFawcett]

Bob, I attached it below

 

[boblarson]

The best way to do this would be to set up your checkboxes as an option group. So instead of having individual fields for each checkbox you would have one for each option group. And then you would store the option number and when an option group is used, by default only one option in the group can be selected.

 

[BrianFawcett]

Bob, I follow you but how to I store the Option Numbers to set up multiple groups. I cannot seem to create multiples.

 

[boblarson]

Bob, I follow you but how to I store the Option Numbers to set up multiple groups. I cannot seem to create multiples.

I'm not getting what you are asking? You have OrderType. That would be a field in your table. OrderTypeID. Then the Option group would be set up and three options set - for Split, Upgrade, and New. You can set each option to have a different value. So you could have Split be 1, Upgrade be 2, and New be 3. So the OrderType option group would be the control bound to the field OrderType and OrderType would be an Integer field and it would store a 1, 2, or 3 depending on the option selected. The option group would be bound to that field. each individual option is not dealt with in any way by you. You act as if they don't exist really. It is the OptionGroup which you get the value of.

 

[BrianFawcett]

Bob, I am sorry if I am being dense or missing something obvious, but my problem is creating there groups. I can create the buttons but not group them together.

I do not know the steps to follow.

Can you possible help me out by walking through one, like for Order Type which you were trying to explain above.

 

[boblarson]

Bob, I am sorry if I am being dense or missing something obvious, but my problem is creating there groups. I can create the buttons but not group them together.

I do not know the steps to follow.

Can you possible help me out by walking through one, like for Order Type which you were trying to explain above.

You're creating the options but you shouldn't be. You need to select OPTION GROUP and go through the wizard. Select this button to start the process:

 

[BrianFawcett]

Thanks Bob, Now I get it, I was just missing the obvious. One follow up, is there a way to format the box itself so the borders and text ("Group Box 62") are not visible.

And can I edit the font of the text for the Option buttons that I add in to the box.