Navigation problem

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Hi all.
I have a problem with a database that I want to edit etc with a form. I
inserted buttons for next record etc. Unfortunately I want to be able to goto
the next alphabetical record (Surname) but of course the navigation buttons
work on record numbers. Is there some way an absolute novice like me can
achieve "next record" by alphabetic sort?
 
I'm not positive I know what you are trying to do from your description.
However, if you base the form on a query, you can sort the query in ascending
Name order which will then present the records to the form in that order
instead of entry order.

With the query in design mode, select, SORT Ascending in the Surname Column

Does this help???

Regards
Mike B
 
Thanks Mike for the incredibly fast reply. By the way I forgot to mention
that I am using Access 2007 (if that makes a difference).
I will give that a go and see what happens.
Thanks again
Geoff
 
You should still be able to base your form on a query in access 2k7 and the
same applies to setting the sort order for (Surname) Field in the query. I
always base forms on queries because you always find someone wants the form
to display in a different order at some time. Also, you can limit the number
of records displayed, perform calcs and do a lot of other things that you
cant do when the form is based on the table. The next record buttons should
still work but will obviously present the next ascending surname order
instead of the record order number.

Kindest regards

Mike B
 
You guys are brilliant!
Thanks very much. It becomes so obvious when it is set out like that.
Very best regards
Geoff
 
Back
Top