lundi 17 août 2020

you entered an expression that has no value with option button

I'm having a option group (Taken) with two options YES(taken_yes) and NO(taken_no) and a text box (If_yes1) which is disable by default. And I want
-if I click YES option, the text box should be enable

  • if I click no option, the text box should be disable and here is the code
    Private Sub taken_AfterUpdate()
    If Me.taken_yes.Value = True Then
    Me.If_yes1.Enabled = True

    ElseIf Me.taken_no.Value = True Then
    Me.If_yes1.Enabled = False
    End If
    End Sub

This is the error

PLEASE! I NEED HELP THANKS

Aucun commentaire:

Enregistrer un commentaire