I've created a standard form for editing one record at a time that uses
the standard MS navigation bar at the bottom to traverse the records.
The navigation bar works normally. When you click on the "Next Record
Button" it takes you to the next sequential record. Basically the
records are traversed in the same order they were created.
But I want the option to go through the records in different
orders
(i.e. by name, address, city, etc.). I've tried setting the Order By
field for the recordset associated with the form to "name" for example
and the code is syntactically correct and executes but it DOES NOT
affect the way the navigation bar goes through records. So how else
would you get the navigation bar to function differently? I'm
stumped.
Sorry if this is a little vague or that I used the wrong
keyword and
that I don't have code samples but I don't have the code available at
the moment but still need an answer. The code is something like
Me.Recordset.OrderBy = "Name" and it works okay at runtime but it
doesn't change the navigation bar functionality at all. Is there a
better way to directly reference the navigation bar properties
itself?
