Initail Sort Event

I was wondering when the inital sort occurs. If I open my solution and navigate to a form that has the initailsort funtion set, it is not sorted. If I go to designer mode and return to browse mode it is sorted.

I would rather use this function instead of a form load / show event method. Please let me know how this event is evaluated.

Thanks Alot,
Erich

Erich,

This event is fired ONLY ONCE - when the form is initally loaded (i.e. equivalent of the “onLoad” form event).

If you want it to sort “all the time” - I would suggest an onShow event.

Hope this helps,

Bob Cusick

That is what I did, I just wanted to know when the initial sort was fired.

Thanks

if you check useSeperateFoundset then you will see it always sorted in the right way, what you specify in the intital sort.

Because if the foundset is already loaded by another form. Then that form has sorted the foundset they way that form specified it. Then when switching to that other form it uses that foundset and because it is already loaded the sort doesn’t happen.

initial sort is more a table property for the foundset, not a real form property.