Solved

access buttons dont go to correct records

Posted on 2013-01-16
7
172 Views
Last Modified: 2013-01-21
I have a form called clients based on a table of the same.
I have several nvaigation buttons at the bottom which I put on using the wizard.

Strangely, the last button does not go to the last entry and the other buttons dont go the right one.

I would expert the "first record" button to go to the first record but it goes for one right in the middle, sequence wise. The only one which works is "add record"   !

Any insight? I have tried replacing the buttons but its the same.
0
Comment
Question by:topUKlawyer
7 Comments
 
LVL 2

Expert Comment

by:ConnerT
Comment Utility
It would be handy if we could have some screenshots to view your problem :)


-ConnerT
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
much better if you upload a copy of the db, so we can see what weird things are on it to cause those behaviors
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
Tables do not have a logical sort order, so if you are simply using the table as your forms recordsource, the records will be presented to you in the order that they were entered (probably), which may not be the order you would like them in.

Create a query based on your table, but sorted the way you want it.  Then change the forms Record Source to that query and see whether the buttons do what you expect
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:topUKlawyer
Comment Utility
Thanks for replies.

I think I have fixed it. The "order by " property for the main form seems to have been the postcode rather than the clients ID.

I have changed it and this seems to work ok.
0
 

Author Comment

by:topUKlawyer
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for topUKlawyer's comment #a38786363

for the following reason:

discovered why I had a problem
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
Did you discover the forms order by property before or after you read my comment?
0
 

Author Comment

by:topUKlawyer
Comment Utility
I am not sure, I think I did, but I am happy to award points for the avoidance of doubt unless there any objections from others.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now