Check box question

[Guest]

I have a form with a check box used to indicate if a receipt is voided or
not. What I'm trying to do is go to a new record after the checkbox is
marked. I have the following code in place and it works. Kinda. The
problem is that if I then go back and UNCHECK the check box, it sends me to a
new record again.

Here's the code:

Private Sub Check43_AfterUpdate()
If Ckeck43 = Yes Then DoCmd.GoToRecord , , acNewRec

Thanks for any help!

End Sub

 

[Guest]

The following works fine for me.

If Me.Check3 = True Then DoCmd.GoToRecord , , acNewRec

so try

If Ckeck43 = True Then DoCmd.GoToRecord , , acNewRec

 

[Guest]

Thanks for the response Daniel. I tried changing it from Yes to True, but
then it doesn't do anything at all.

Any other thoughts?

Thanks!