gearhead03
New member
- Local time
- Today, 09:11
- Joined
- Apr 3, 2012
- Messages
- 2
I am using a yes/no box on a Continuous Form. This code works;
the appropriate boxes update with the proper information.
I need to also have the information removed if the box is unchecked. I have this code but nothing happens when I use it. What have I done incorrect?
Code:
Private Sub Check38_AfterUpdate()
Me!HERITAGEPAIDDATE.Value = Me!DateReceived
Me!HERITGAEPAIDCHKNUM.Value = Me!CheckNumber
End Subthe appropriate boxes update with the proper information.
I need to also have the information removed if the box is unchecked. I have this code but nothing happens when I use it. What have I done incorrect?
Code:
Private Sub Check38_AfterUpdate()
If Me!Check38.Value = yes Then
Me!HERITAGEPAIDDATE.Value = Me!DateReceived
Me!HERITGAEPAIDCHKNUM.Value = Me!CheckNumber
Else
Me!HERITAGEPAIDDATE.Value = ""
Me!HERITGAEPAIDCHKNUM.Value = Me!CheckNumber
End If
End Sub
