2 Fields criteria to auto fill a Third Field on Form

[Helpee]

*SOLVED*
Hi All, novice I'm afraid. Issue I could do with some help with is all on a single form. I have a checkbox called chkStartForm and a Textbox called Text127. I want to auto change a combobox called Frm1Q1Response from 'Yes' to 'N/A' if the Checkbox is Clicked AND the Textbox has a specific Word in it (call it 'Sharps'). I didn't need this second criteria and ran the change of combobox straight from the Checkbox as follows: -

Private Sub ChkStartForm_Click()
If Me.ChkStartForm = True Then
Me.Frm1Q1Response = "N/A"
End If
End Sub

Now I have this second criteria I'm stuck. Just getting back into Access after many years of wilderness. Help please with my 1st posting. Many thanks.

 

[Helpee]

Done it. Been an idiot. Code is simply: -
Private Sub ChkStartForm_Click()
If Me.ChkStartForm = True And Me.Text127 = "Sharps" Then
Me.Frm1Q1Response = "N/A"
End If
End Sub