Using a Checkbox to enable a textbox for current record

[Jonnip]

Hello there,
first post here so take it easy! also i am a amateur so please be patient!

I have a subform with 3 fields:
Role (combobox)
Suitable (checkbox)
Notes (textbox)

all the fields are bound
what i want to happen is the notes textbox is enabled ONLY when the suitable checkbox is checked.

i am using this code:

Private Sub chkSuitable_Click()
    If Me.chkSuitable.Value = True Then
    Me.txtNotes.Enabled = True
    Else
    Me.txtNotes.Enabled = False
    End If
End Sub

Private Sub subfrmVolunteer_Current()
    Me.txtNotes.Enabled = False
End Sub

however what is happening is once i check the box once the text box remains enabled for all records.
the form is intended to be viewed in datasheet view
Thanks

Jonni

 

[JPaulo]

Hi;

Use Conditional Formatting in txtNotes you Enabled or no.

See attch

 

[Jonnip]

thanks so much

 

[Jonnip]

thank you

 

[JPaulo]

thank you for replay.