sort without closing

[maxmangion]

i have a continuous form, which on it i have an unbound text box which displays a calculated value. Now my form is sorted in descending order based on the value in the unbound text box.

Now, i would like that when i do some changes, i would like to re-sort the form in real-time i.e. not having to close and re-open the form. I thought of using the after update event of the unbound text box, but as far as i am concerned the after update event of a calculated "never occurs".

Is there any way, in which i can sort without having to close the form ?

Thank You

 

[Meltdown]

Make a custom toolbar and add the "Sort A - Z", "Sort Z-A" buttons to it.

 

[maxmangion]

actually, i am aware of using the Z-A button, but i would like that as soon as i change any data, i will see the sorting occur automatically, without any intervention.

i manage to do this with under normal circumstances, but since this time, i have a unbound field displaying a calculated value, i am stuck.

Thanks

 

[Meltdown]

have you tried...

Me.OrderByOn = True
Me.OrderBy = "Your_Sort_Field DESC"
Me.Refresh

...on the OnDirty event

 

[maxmangion]

i've tried your suggestion, but unfortunately to no avail.

 

[Meltdown]

...what about the After_Update event of the controls you're changing, that code will cause a sort/refresh.

 

[aleb]

What events trigger the change in calculated field ?

 

[maxmangion]

following your suggestion, i've tried putting the code on the fields of the controls which i change ... and finally it is working fine, however, the only minor problem which i have is that after the afterupadate event, the sort occurs automatically (as i wanted), but the focus, moves directly to the first record, rather than staying on the same record which i was changing.

Any ideas, how can i keep the focus from moving to the first record ?

Thank You