Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    23

    Unanswered: How to make disabling and enabling of radio button

    I want to be able to disable groups of radio buttons on the MSAccess form if one of the “Upper Case” radio button in Fram_1 is checked both Frame_2 and Frame_3 disabled. The code I have seemed not to work. I must confess that I have done everything possible to get this working. Please I need help.
    Thank you very much

    Frame_1
    -----------------------------
    Compliant
    O Person Answered
    O Recorded Message

    Non Compliant
    O PHONE CONTINUE TO RING
    O NO EMERGENCY CONTACT
    ----------------------------------

    Frame_2
    -------------------------------------
    O wrong Phone Number
    O Don’t Know
    O Response No
    O Refused
    ------------------------------------

    Frame_3
    ------------------------------
    O wrong Phone Number
    O Don’t Know
    O Response No
    O Refused
    ---------------------------

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Please post your code.

  3. #3
    Join Date
    Jun 2008
    Posts
    23

    how to make disabling and enabling of radio button

    I want to be able to disable groups of radio buttons on the MSAccess form if one of the "Upper Case" radio button in Fram_1 is checked both Frame_2 and Frame_3 disabled. The code I have seemed not to work. I must confess that I have done everything possible to get this working. Please I need help.
    Thank you very much

    Frame_1
    -----------------------------
    Compliant
    O Person Answered
    O Recorded Message

    Non Compliant
    O PHONE CONTINUE TO RING
    O NO EMERGENCY CONTACT
    ----------------------------------

    Frame_2
    -------------------------------------
    O wrong Phone Number
    O Don't Know
    O Response No
    O Refused
    ------------------------------------

    Frame_3
    ------------------------------
    O wrong Phone Number
    O Don't Know
    O Response No
    O Refused
    Private Sub Frame1_AfterUpdate()
    Dim flg As Boolean

    If Me!Fram_1 < 3 Then
    flg = True
    Me!Fram_12.Enabled = flg
    Me!Fram_21.Enabled = flg

    Else
    Me!Fram_12.Disabled = flg
    Me!Fram_21.Disabled = flg

    End Sub

    Private Sub Frame28_Click()
    Dim flg As Boolean

    Select Case flg

    Case Is < 3
    flg = True
    Me.Option29 = True
    Me.Option31 = True

    Me!Fram_12.Enabled = flg
    Me!Fram_21.Enabled = flg

    Case Is > 2
    flg = False

    Me.Option29 = False
    Me.Option31 = False

    Me!Fram_12.Disabled = flg
    Me!Fram_21.Disabled = flg

    End Select

    End Sub

  4. #4
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Private Sub Frame1_AfterUpdate()
    Dim flg As Boolean

    If Me!Fram_1 < 3 Then
    flg = True
    Me!Fram_12.Enabled = flg
    Me!Fram_21.Enabled = flg

    Else
    Me!Fram_12.Disabled = flg
    Me!Fram_21.Disabled = flg

    End Sub
    What is Frame_1,should it be Fram_1?

    Try this

    Private Sub Fram_1_AfterUpdate()
    Select case Fram_1
    Case 4,5
    Me!frame_2.Enabled =False
    Me!frame_3.Enabled =False
    Case Else
    Me!frame_2.Enabled =True
    Me!frame_3.Enabled =True
    End Select

    End Sub

  5. #5
    Join Date
    Jun 2008
    Posts
    23

    how to make disabling and enabling of radio button

    Allan,

    Thank you very much, the code for how to make disabling and enabling of radio button works fine.

    Osimini

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •