Radio Buttons in Option Group will no longer fill-in after being formatted

[Hope Warren]

Hello,



I have several sets of radio buttons in group options on my split form that were working just fine (filling-in when selected and recording the data to my table) before I added a code to the "After Update" event tab (see code below). Once I put the code in the buttons would not longer fill in to show as selected. They do still record the formatted information on the table (title of button instead of the number). I cannot figure out what how to fix this. Can anyone help?

Private Sub FRAME_Review_Status_AfterUpdate()
Select Case FRAME_Review_Status.Value
      Case 1
         FRAME_Review_Status.Value = "Review NA"
      Case 2
         FRAME_Review_Status.Value = "Pending DLR Conf"
      Case 3
         FRAME_Review_Status.Value = "Pending Analyst Review"
      Case 4
         FRAME_Review_Status.Value = "Pending DS Review"
   End Select
End Sub

[ItsMe]

Maybe double check to make sure the name of your Option GROUP is actually FRAME_Review_Status

Use your mouse pointer to left swoop over a corner of the group to highlight it. Then check the name and the Event. The only other thing I can think of is maybe you copied your option group from one form to another. Need to create option groups with the wizard.

[Hope Warren]

Thanks for your reply. Yes, the names are equal. It also records the formatted data when you select it, the dot just does not show as selected.

[ItsMe]

When you create an option group using the Wizard, you will tell the wizard what the value of the Option Group is. So there is not a need for
FRAME_Review_Status.Value = "Pending DLR Conf"

You would type the value you want as a step within the wizard. So if the value is 1 and then you try to change it to Review NA, this could cause unexpected behavior

[Hope Warren]

It does not give you an option to change it in the Wizard...only the option to control/renumber each button

[ItsMe]

It was not my intention for you to infer that it can be edited. When you create an option group, the Wizard steps you through the process.

[Hope Warren]

I tried that previously but, when using the wizard, I named the buttons to be what I wanted and the only other place it takes you to insert additional information is the "option value", which must be a numeric value.

[Missinglinq]

To begin with, using code like

FRAME_Review_Status.Value = "Review NA"

is not 'formatting' anything, it's assigning a value to FRAME_Review_Status! And therein lies your problem! The value of any Option Group can only be an Integer! It cannot be Text, which is what you're trying to do and why the radio buttons are not working after the assignment of a Text value!

Linq ;0)>

[Hope Warren]

So, are you telling me there is no way to use the two together? It updates the field in my report with the text...it will just no longer fill in the dot...

[ItsMe]

Why don't you start by explaining what the option group is supposed to accomplish. If a User ticks an option, what does that do for the User, from a business rules perspective?