> I have a form with navigation button and they brows through the
records. How to change the order or the way these records are
navigated?
Like before based on ID, now I want based on another field, like Name
field.
Your request if posted in an incorrect way.
I suppose you would like to order records shown into a form, so to "navigate
them basing on the field you ordered them".
If this is your case, you only have to use OrderBy and OrderByOn form properties.
Otherwise you can add an ORDER clause to the data source of the form.
--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution