Help with Next button

[zykon]

Hello.
I have created a command button which i want to use to select the next customer in a drop down box from my form. I have used the code below.

Private Sub Find_Next_Click()
Surname.SetFocus
DoCmd.FindRecord (Surname),,,,,,False
End Sub

Using this code, when i press the next button with the first record it jumps to my final record instead of going throught each individual record. Can anyone please suggest how i can get the next button to go through all the customers stored instead of just jumping to the last one.
Thank You for your help.

 

[adevera]

Are you saying that, when you press the next button, your drop down value will be the next record on your table?

I am getting this right ?

 

[zykon]

Yeh
When i press the next button i want the next record on my table to be displayed, but instead the next button jumps to the last record on the table.