How can I go to Record Number?

[alexandervj]

Hi,

I've got a edit part form that works great but would like an input field on the form where I can specify the record number to go to.

Right now I have a parts list form, then when you click on a specific record number in the parts list the edit part form comes up in a dialog for that specific record number and you can edit it there. Theres also an 'edit part' form tab that is pretty useless right now, but what I want to do is have a record number input field on the edit parts form in case the dialog popup doesnt work (which it seems to always have problems and doesn't work on Firefox). There is the record number you see at the bottom of the attached image which I can put a number in and press enter. This is the kind of functionality I'm looking for, BUT this doesn't take into account deleted records - so say there are records 222, 223, and 224 and record number 223 is deleted - the problem with this way is now record 224 becomes record 223, however the assigned record number for this is still 224 in the parts list so you cant input this in the field. I guess if I could find a way to update the record numbers to account for deleted records that would be fine too.. that might be an easier solution... i dont know, what do you think? Thanks!

[orange]

Your attachment is out of focus and can not be read.
In Access relational database there is no record number. You could assign a part number and search/filter for that. If you want records in a particular order, then create a query and define the Order By.

[June7]

The record number in the navigation bar has nothing to do with the ID generated by autonumber field and isn't supposed to. Users shouldn't even be aware of the autonumber generated ID which is intended to serve as a PK/FK link between related tables, not as an identifier that has meaning to users, like a SSN.

Why do you delete records?

Various methods to search/filter records on form:

1. parameterized query (I don't use), review: http://datapigtechnologies.com/flash...tomfilter.html

2. code to set Filter and FilterOn properties of form (I use this)

3. code to move to a record (I use this)

4. code to modify the RecordSource property with an SQL statement that has filter criteria (I have used this for a report)