Before Update on record select

[jk]

I am getting no where fast. I have a main form and sub form and what i need
is a message to appear when user moves on to the next record using the record
selector on the bottom of the form. I have tried the beforeupdate on the form
but no results. Can form design prevent a message prompt?

 

[Klatuu]

You want the form Current Event. It fires each time the record changes.

 

[jk]

That was it. I am using a code that was kindly provided from this news group
as follows:

Private Sub Form_BeforeUpdate(Cancel As Integer)

Resp = MsgBox("DO YOU WANT TO CONTINUE TO NEXT CUSTOMER?", vbYesNo, "Stop!")
If Resp = vbNo Then
Cancel = True
End If

End Sub

Message comes up but even answering the prompt with " NO" , it still allows
the user to click the recorder selector to move onto the next customer. What
needs to be changed for the message to really work?

 

[Klatuu]

One problem is that if no changes to the current record have been changed,
the Before Update event will not fire.
If you do make a change, the code as is should work.
I have gotten into the habbit of not using the standard record navigators,
but write my own so I can easily deal with this.

 

[jk]

Thanks. To write code is a tad above what i am learning and i guess the
message box (even though it will not stop them) it will flag the user that
they have gone onto another customer. I appreciate the help on this.