I have an ADP linked to an SQL server and the main form we use is the production form which is set up as a Continuous Form. All works well except for a very annoying jumping around when inputing data.
For instance if I sort the date column (right click sort) and the change a records date field the form goes from being sorted by date to something different. the same happens if I sort any other fields and try and change that fields data then the screen jumps about and unsorts itself. It doesn't happen if I sort one field and change another.
Hope this makes sense and is there a solution ?
For instance if I sort the date column (right click sort) and the change a records date field the form goes from being sorted by date to something different. the same happens if I sort any other fields and try and change that fields data then the screen jumps about and unsorts itself. It doesn't happen if I sort one field and change another.
Hope this makes sense and is there a solution ?