Hi Trent

Sorry but I dont' have any sort or filter in the form. As I show before the SELECT statement has a ORDER BY and yes the order is respected when the form loads, the only thing is that the record that shows when the form is opened is the second one and the first one.

I review the forums yes but at least the ones I tale a look was on how to use a SORT or how to after save show the records sorted again.

I will review again, maybe as you said is the CurrentIndex... that goes to the second record and I don't know why?

regards

Everything is possible, just keep trying...

You can actually find your answer to this throughout the forum....it becomes a common post.  You have a sort or filter set on your BO which changes the order of the internal data table, but the CurrentRowIndex is left the same.  So when you add a new record or modify a column that is part of the sort or filter, you will either need to clear the sort or filter or take this into account.  This is a very common thing that we see out here on the forum, but I am 99.99% confident that you have a filter or sort applied to he BO or something along those lines that is changing the order of the records in the BO.

Hi

I have a curious situation. I have a table for families, the BO has this method:

Public Sub FillAllRecords()

Me.FillDataTable("SELECT * FROM Familias ORDER BY Apellidos")

End Sub

I add three records, one begin with H, second with D and las one with A. Every time I load the maintenance form, goes to the second record in this case the one beginning with D, the order is correct, the first record is the one with A but I can not understand why goes to the second one.

Regards

Everything is possible, just keep trying...