Using a combobox to scroll through records.

[Mbri]

We need to be able to select a record using a combobox and to make sure that the indexed record counter on the navigation bar at the bottom of the screen matches the selected record. Currently, the records become rearranged depending on what record the navigation bar is on.

 

[Norris68]

Access has a wizard that will navigate to a record - select the "Find a record on the form..." option.

If you want to navigate by the record numbers, you can just over-type the number in the navigation bar to jump to it - you don't need a combo box.

 

[Mbri]

That solution won't work for us. It is required that we have a combobox so that the company that we are making the database for can choose from a list of about 160 different functional locations. It would not be possible to remember which record corresponded with which number on the navigation bar. Any other ideas???

 

[Norris68]

I think you are going to have to explain a little more clearly.

By the way, the wizard I mentioned in my last post is triggered when you drop a combo box on the form, and will create the code to navigate to a specific record when the user selects it in the combo.

The navigation bar at the bottom is fixed and will display the sequence number of the current record within the current recordset. It cannot be changed (except to navigate), and is functionally equivalent to Me.Recordset.AbsolutePosition+1.

 

[Mbri]

We tried the wizard, which would work, except for that we got Runtime Error 2105. It didn't like the expression...

Me.bookmark = Me.RecordsetClone.Bookmark

 

[papernate]

I am having the same problem, this line here causes me problems:

If Not rs.EOF Then Me.Bookmark = rs.Bookmark

My error message is "'2001' You cancelled the previous operation"