Forms - Radio buttons

[Sheba]

I need help with this please. I have come close to losing my hair because the stakeholders of my project have changed the design yet again. Instead of using combo boxes, I now have to use radio buttons. I'm trying to figure out how to represent each option button on the table. Let me clarify:

I used a value list on my table as the row source for my combo boxes on my forms. Now I'm wondering how to adjust the table design to work with the radio buttons instead? The row source feature is not showing in the radio button property

[Sheba]

I think I figured it out. It is the 'group' control that I'll bind to the value list in my table not the individual buttons.

[June7]

Usually, radio buttons are used in a situation where only one selection is allowed. The radio buttons would be components of an Option Group control. Clicking a button assigns a number value to the Option Group control. The Option Group control can be bound to a field and the assigned value will be saved. Customary situations where only one selection is allowed are: Yes/No, Male/Female, Poor/Good/Fair/Excellent.

EDIT: Did not see your second post before mine committed. Glad you figured it out.

[Sheba]

no worries thanks allthesame

[Sheba]

Hey June7, could you help me with these please? I have a group control which consists of check boxes. I find that:

1) I cannot check more than one box in a group, I need to be able to do this.

2) my table field had values "Yes","No","undetermined" but when I make my selections and save, the values are saved as "1", "2", "3". How do I fix this please?


3) also if I check a box in the group and decide that I don't want any of them checked, I'm unable to do this. Not sure if this is clear or not but once a box in the
group is checked, I can't undo this.

Any help with this is appreciated

[June7]

1. Why would you want to check more than one button in a group? Purpose of option group is to limit selection to one item.

2. Would have to use code to translate the number values to text and save

3. true, which is probably why I've never used option group for saving data

[Sheba]

not the radio button but the 'check box'. I used check box option group as well. Is there any way I can make it accept more than one checked box?! It will be terrible if I have redesign this redesign

could you help me with the code to translate this please?

[June7]

An option group will allow only one selection. Don't put checkboxes within option group. Bind each checkbox to its own field. If you want to save multiple choices to a multi-value field, then need combobox or listbox. I never use multi-value field.

Me!fieldname = Choose(Me.optiongroupname, "Yes", "No", "Undetermined")

[Sheba]

thank you June7. Just to be sure, this code goes into the AfterUpdate event of the option group control correct?

[June7]

I would think so.

[Sheba]

Hi June7. I put this code in the AfterUpdate event of the option group but now I can't make a selection. When I click on the radio buttons, no selection is made

Me!O2SaO2 = Choose(Me.SaO2, "Yes", "No", "Undetermined")

O2SaO2 = table field name
SaO2 = option group name


? I used it for the first option group and was going to test it but it is complaining about the 20 other option groups that I haven't adjusted. Just checking first before doing the wrong thing 20 more times.

Also in the code, does fieldname
just to be clear in the code, fieldname refers to the table field, correct?

[June7]

Yes, use table field name, assuming it is included in the form RecordSource.

Do not bind the OptionGroup control to the field.

[Sheba]

June7 you rock!
you just saved a life. again!

it worked thank you.

[Sheba]

one thing though...

how do I get a clean form after I save After I click the SAVE button, the other fields are cleared but the radio button and check box selections remain on the form

[June7]

The OptionGroup control must be unbound because you want to save text, not the number values. Unbound controls retain their values. Must use code to set the control back to Null. In VBA:

Me.OptionGroup = Null

Did you bind the checkboxes to fields?