Keep Option Group Value 2

[MeldrethMan]

I'm using an option group to set the value of a text field on a form.

Select Case Me.ogHomeType
Case 1
Me.HomeType = "IL"
Case 2
Me.HomeType = "F1"
Case 3
Me.HomeType = "SH"
Case 4
Me.HomeType = "RH"
End Select

When reopening the form all the option radio buttons are blank, which is confusing for users. If HomeType has value SH for example, I'd like radio button 3 to show up as selected.

 

[PHV]

You may try this in the Current event procedure of the form:

    Select Case Me.HomeType
    Case "IL"
    Me.ogHomeType = 1
    Case "F1"
    Me.ogHomeType = 2
    Case "SH"
    Me.ogHomeType = 3
    Case "RH"
    Me.ogHomeType = 4
    End Select

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

I would store the number rather than the text in the field so that you could bind the option group to the field. Your kludge workaround is to set the value of ogHome in the On Current event of the form. The code would be the opposite of your Select Case statement

   Select Case M.HomeType
    Case "IL"
        Me.ogHome = 1
    Case "F1"
        Me.ogHome = 2
    Case "SH"
        Me.ogHome = 3
    Case "RH"
        Me.ogHome = 4
   End Select

Duane
Hook'D on Access
MS Access MVP

 

[dhookom]

Looks like PH and I posted about the same time and he didn't miss the "e" in "Me.HomeType"

Duane
Hook'D on Access
MS Access MVP

 

[MeldrethMan]

Great, thanks chaps, that works just fine. Much appreciated.