Chage field Value if checked

[amfroehlich]

I have a tabular form where i want to chage a fields status from it current value to "Complete if a check box is filled in. What is the VBA for this?

Thanks

 

[Norie]

You could try something like this:

Private Sub Check1_Click()
    If Check1 Then
        Status = "Complete"
    End If
End Sub