Moving to next/previous record in a form.

[ser01]

I have a form that has a text box in the header. It is bound to a [Customer_Name] field in a customer list table. I would like to have a button(s) that would allow me to move to the next/previous customer.
I have tried a few things:
DoCmd.RunCommand acCmdRecordsGoToNext
DoCmd.GoToRecord acDataTable, "tblCustomerList", acNext


Also tried to use the control wizard. That generated a macro for the move next, but it did not work. What gives?
Any suggestions would be appreciated.

[June7]

Try the MoveNext and MovePrevious methods. Example:
DoCmd.GoToRecord acForm, "SampleInfo", acPrevious

Review http://bytes.com/topic/access/answer...ns-access-form

Here is another way http://www.java2s.com/Code/VBA-Excel...NextButton.htm

[ser01]

Thank you very much for your reply.
I tried the method described here last night, and it did not work. I got an error about the table not being opened. However, I tried again just now and it works fine. Very strange.
Again, thanks for your help.

[Missinglinq]

Private Sub cmdNext_Click()
  If CurrentRecord = RecordsetClone.RecordCount Then
    MsgBox "You are on the Last Record!"
  Else
    DoCmd.GoToRecord , , acNext
  End If
End Sub

Private Sub cmdPrevious_Click()
  If CurrentRecord = 1 Then
    MsgBox "You are on the First Record!"
  Else
   DoCmd.GoToRecord , , acPrevious
  End If
End Sub

Linq ;0)>