User Selected Record # not working properly

[jtm013]

Hello,

I have a form which is used to edit data. I have it set up so that on open the user must input the record number they wish to edit.

Private Sub Form_Open(Cancel As Integer)
Dim ControlNumber As String


'This requests the user enter the desired control number
ControlNumber = InputBox("Please enter your lowest Control Number", _
         "Input Required", "001")


DoCmd.OpenForm "frm_pmTensileTest", , , "ControlNumber = " & ControlNumber


End Sub

The problem is that usually a user will need to edit multiple records and after they select their first record the form is filtered to only have that record available. This causes problems because the way this is used a user may need to edit record 642, 643, and 644. They will never need to go backwards. Subsequently this form is to allow the user to input their lowest control number (642 in our example) and then there is a Next Record button which allows the user to move forward to records 643 and 644. Since the above code filters the form to only have the specified record available the next button will not allow the user to move to the next record.

Any and all help is appreciated. Thanks!

[pbaldy]

Is this what you want?

http://www.baldyweb.com/Bookmark.htm