Check box question

  • Thread starter Thread starter tlamm via AccessMonster.com
  • Start date Start date
T

tlamm via AccessMonster.com

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. If I uncheck it, I want it to stay on that record.

Here's the code:

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

End Sub

Thanks in advance for any help!
 
Back
Top