Record ID not matching Form ID

[accessmatt]

Hello,

I'm wondering why the Record ID in my Form doesn't match the ID of that record in the system. This is consistent across all of my records? Does anyone have an explanation?


Thanks,

[pbaldy]

What you've pictured is simply the total record count and the position within that count of the record being displayed. There is nothing data-related (like the ID number) being displayed.

[accessmatt]

Pbaldy, That's exactly the issue. I *want* to be able to link the record with it's ID so that it can be easily referenced if needed. For instance someone could export a report of all IDs and records, find the ID that they want and then plug it into that little box to go directly to it.

[pbaldy]

I don't think it's possible with the built-in navigation buttons. You'll have to create your own, perhaps using the bookmark code the "find a record" combo would use.

[John_G]

The record counter at the bottom of the screen cannot be used to do what you need to do. As Pbaldy pointed out, those counters have no relation to the data in your records - none. They are entirely dependent on the sort order currently in effect on the form, and every time you sort on a different field in your form, a different record will be record 1 of 117 (as will most of the others) - MS Access does not have "record numbers" as such.

What you will need to do is put an un-bound text box on the form, enter the unique ID of the record you want to search for, and then go to that record with VBA.

Alternatively, you can click on the ID field in the form, then use Find (in the ribbon) to locate the record you want.

[accessmatt]

pbaldy & John G. Thanks. Could you offer any assistance with the VBA if I used the unbound textbox to lookup an ID?

[pbaldy]

You can adapt this:

http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx