After you set the Orderby to the field name you must set the OrderbyON = true
--- In [email protected], "bryan.leggo" <[EMAIL PROTECTED]> wrote: > > 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? >
