Dlookup when yes/no box clicked

[whojstall11]

I have a table (Current Meds) nested on my form that has a yes/no box (discontinue) clicked in every data entry. When i click on the yes/no box (discontinue) I want to copy data from that row and add it to a different nested table (tblNotesCurrentMeds) on that same form. I cant get it to work can anybody help my code so far.

 	Private Sub Discontinue_AfterUpdate() If Discontinue = -1 Then Initial = DLookup("Initial", "Current Meds", "IDCurrentMeds = '" & [IDCurrentMeds] & "'") Else End If End Sub

​

 

[jdraw]

I do not understand you post.

I have a table (Current Meds) nested on my form

and your code is all on one line
I have reformatted your code

Private Sub Discontinue_AfterUpdate()

    If Discontinue = -1 Then
        Initial = DLookup("Initial", "Current Meds", "IDCurrentMeds = '" & [IDCurrentMeds] & "'")
    Else
    End If
End Sub

 

[whojstall11]

Im going to attach my db I dont know another way to explain it View attachment test1_be_Backup.zip