asked on

access buttons dont go to correct records

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.

ConnerT

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

-ConnerT

Rey Obrero (Capricorn1)

much better if you upload a copy of the db, so we can see what weird things are on it to cause those behaviors

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richard

ASKER

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.

Richard

ASKER

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

Dale Fye

Did you discover the forms order by property before or after you read my comment?

Richard

ASKER

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.