WendellB (12/17/2014)
The order of records being displayed on a form is determined by the record source for the form - so if your form has a SQL statement as its record source, and that statement has an ORDER BY clause, then the records will be displayed in that order. So if you want to change that order based on changes in the data or some other external source, you have to at a minimum refresh the form using either a macro or VBA, or in some cases you may need to dynamically change the record source in VBA. Hopefully that is enough to get you started.
Yes, I use SQL statement for my form with ORDER BY clause, it is ok, but I need to also dynamically change the order of records, based on actuall view in form, and also user should also change the order of records.
I dont know how to ... at first I'm trying to number(sort) every record from 1 to N, in actual view form. This is also problem, how to do it...