Want the code to work for current record

[jj1]

I am using the code below. I have a form where I have a check box "WasIssueresolved" which if checked or is true should populate today's date in the closedate text box and at same time populate the name of the person signing in. Code works perfect. What I want to do is I want code to work only on the current record. What's happening currently is that when I put "WasIssueresolved" as False then closedate text box becomes hidden but for all records. This is what I don't want. Let me know if I am clearly stating my problem. I am learning how to state it .

I know about the on current event but I already have some code on the current event of the form

Private Sub WasIssueResolved_Click()
'On Error Resume Next
If WasIssueResolved = True Then
     Forms!Ucondition!CloseDate.Visible = True
     Forms!UCondition!CloseDate = Date
     CloseDate.Locked = True
     PersonClosingtheIssue = Me.txtUsername
     PersonClosingtheIssue.Locked = True
    Else
        If WasIssueResolved = False Then
        Forms!UCondition!CloseDate.Visible = False
        Forms!UCondition!CloseDate = Null
        CloseDate.Locked = False
        PersonClosingtheIssue = Null
        PersonClosingtheIssue.Locked = False
     End If
    End If
End Sub

[ranman256]

You cant do this for CONTINUOUS FORMS. This can only be done in SINGLE record form.
Continuous ALL boxes get the same treatment...just different data.

NOW a query ,using your various conditions, can give you the true/false fields and show THEM on a continuous form.

[pbaldy]

You can use Conditional Formatting to achieve the look you're after.

[jj1]

It's a single record form which has the check box and text boxes to be populated. How can I use the query to perform this action

You cant do this for CONTINUOUS FORMS. This can only be done in SINGLE record form.
Continuous ALL boxes get the same treatment...just different data.

NOW a query ,using your various conditions, can give you the true/false fields and show THEM on a continuous form.

[jj1]

How can I use conditional formatting to do this. Please explain me the steps

You can use Conditional Formatting to achieve the look you're after.

[pbaldy]

If it's a single record form, you just need to add code to the current event to handle the changing of records.

[jj1]

Thanks it worked

[pbaldy]

No problem.