Use a command button to remove data from a record

[scoe]

Hi, being new at VBA I am struggling a little and would be greatful for more advice.
I have a button in the detail section on a continuous form that when clicked brings up a message asking if you want to edit the record, if 'yes' I need two fields deleted, the tick out of the [TBC] chkbox and the date from the [ClaimDate]which is drawn from the table.
So far I have the following code but only the message works.
[Private Sub Command138_Click()
MsgBox "Are you sure you want to edit recorded claim?"
Style = vbQuestion + vbYesNo
If Response = vbYes Then
Me.TBC = False
End If
End Sub]

Any help would be greatly appreciated

[JoeM]

You need to catch the response in a variable, i.e.

Private Sub Command138_Click()

    Dim myResponse

    myResponse = MsgBox("Are you sure you want to edit recorded claim?",vbYesNo)
    If myResponse = vbYes Then
       Me.TBC = False
       Me.ClaimDate = ""
    End If

End Sub

[scoe]

Thank you so much, it's worked with the date just need to get it to take out the tick, not sure why it is ignoring that part but getting closer, thank you.

[scoe]

Thank you, my error (mispelled the check box) works brilliantly