Copying information to next record

[CleverOne]

As the title states i want to copy a textbox value from one record to the next when a checkbox is enabled. this is the code i wrote but i guess i am missing something or putting it in the wrong place.

Private Sub txtTRKNUM_AfterUpdate()
If chkTRACKLOCK.Value = Checked Then
txtTRKNUM.DefaultValue = txtTRKNUM.Value
End If
End Sub

 

[dan1dyoung]

Try Yes & No in place of Checked

I have:

If Me.Check11 = Yes Then
Me.Text13.Value = ""
Else
Me.Text13.Value = Date
End If

And it works OK, except Yes is NOT checked???

Thanks

Dan

 

[CleverOne]

Try Yes & No in place of Checked

I have:

If Me.Check11 = Yes Then
Me.Text13.Value = ""
Else
Me.Text13.Value = Date
End If

And it works OK, except Yes is NOT checked???

Thanks

Dan

Thanks Dan,
That worked like a charm.

 

[dan1dyoung]

Good, glad you got it sorted

Dan