Change GoTo record properties?

[dpags]

Hi, is there a way to make the GOTO first,previous,next,last record buttons go through the values in an alphabetically sorted field instead of by the record ID numbers? For example, I placed these four command buttons on my form and when I hit the goto last record one I'd like it to go to my last alphabetical field entry "Zoology" instead of the last record I had inputted.

Thanks.

 

[lupins46]

Sort you table using the toolbar sort buttons first.

If you are saying you always want it to work that way then base your form on a query which sorts the way you want it.

 

[TheAceMan1]

How are ya dpags . . . .

Set the forms [blue]RecordSource[/blue] to a query or SQL and do your sorting there.

See Ya! . . . . . .