Check box question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
The following works fine for me.

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

so try

If Ckeck43 = True Then DoCmd.GoToRecord , , acNewRec
 
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!
 
Back
Top