I have a small database I've recently created. I'm using the data access pages to enter and view the data. On the bottom of the page I have the navigation bar that allows me to jump through the data, add new, etc. I have created a unique id number that is the primary key. A while back I opened the page and noticed that the item displayed was not the last one I entered (which it usually does) and instead was showing an entry several numbers back (the last id number I had entered was 1201 and it was showing 1168. I clicked on last item and it went to 1167. I clicked on first item and it went to 1168. I can click on the previous button and go all the way back to the first entry but cannot go forward past 1168. Now when I've created new items, they are all showing up in the table. Does any of this make sense and can someone maybe help me out? I would greatly appreciate it!!

Shane

The only thing I can think of is that the sort is on some other field, and going to the last record goes to the last value in the sort field, not the last value in the PK field. Perhaps the last value on the sort field is PK 1168, and coincidentally the first value in the sort field is 1167? This could be the case if you are not sorting on the PK.

HTH


mmcdonal

Is there a way to configure the commands on the built in navigation bar?

Thanks!
Shane