Move between records on a form

[papasmurfuo9]

Hi

i have a form, where a user inputs a account number
inputting the account number, then populates all the relevant table fields, into the form for the user to edit.

however if there is more than one account, with that account number, how do i get it so they can cycle through on the form?

thanks inadvance

 

[pr2-eugin]

What is the code you are using right now?

 

[papasmurfuo9]

i have a unbound combo box called "Txt_Store_No" where the user inputs a store number

then the form, its record source is

SELECT Tbl_Test_Closed_Accounts.Fld_Store_Number, Tbl_Test_Closed_Accounts.Fld_Test_Account_Number, Tbl_Test_Closed_Accounts.Fld_Request_Date, 
FROM Tbl_Test_Closed_Accounts
WHERE (((Tbl_Test_Closed_Accounts.Fld_Store_Number) Like [Forms]![Frm_Master_Unit_List_Closed].[Txt_Store_No] & "*"));

on the unbound

Private Sub Txt_Store_No_AfterUpdate()
Me.Requery
End Sub

then it pulls through all the record detail for that store number, just problem is if there is more than one, it firsts the first store
i need to be able to cycle through all stores wit that number on the form.

thanks