Go To Next Record

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have the following AfterUpdate Event procedure on a form that takes the
user to the next record, when an amount is entered and the Enter key pressed.
This field defaults to 0.00. Sometimes the amount does not need to be
changed. What I would like is if the amount remains as 0.00 and the Enter
key is pressed, the user is taken to the next record:

Private Sub W1_AfterUpdate()
On Error GoTo Err_Next_Envelope1_Click


DoCmd.GoToRecord , , acNext

Exit_Next_Envelope1_Click:
Me.W1.SetFocus
Exit Sub

Err_Next_Envelope1_Click:
MsgBox Err.Description
Resume Exit_Next_Envelope1_Click


DoCmd.RunCommand acCmdSaveRecord
End Sub

Any help would be appreciated
 
Thanks for that Accessvandal,

However, I do not want the user to skip the record if the value is 0.00, as
often they will need to enter a figure. If the figure stays as 0.00, and
they press Enter key to accept this, then they will be taken to the next
record.

Any other clues?

With Thanks
 
Back
Top