OrderBy becomes alive on it's own

[waldemar]

Now this definitly looks like an access bug and I would be glad if anybody could confirm that...

From time to time I set the Order and OrderBy property of a main form and a continous form (same recordsource query) to a selection by the user. (

http://www.rixcafe.de/frontend.gif)

When the user clicks on some entry in the continous form "DoCmd.GoToRecord acDataForm, Me.subform.Name, acGoTo, Me.CurrentRecord" causes the main form to display the details of the same entry. One problem that we discussed here already is an automatic requery of both forms due to a reference inside the query (to another 4rd form).

But this is new:

I don't know since when this happens, but if click two times in that endless form (no doubleclick), the continous form starts reordering itself (checking the order property reveals the correct order shoudl be applied!!), some strange order, that is neither saved in the form nor ever called by vba....

Anybody knows this is a bug?

regards
waldemar

 

[waldemar]

In addition.... I checked the query behind the forms, which seems to be the origin of the chaos.

It feels now, that sometimes access goes automatically back to the original query order (I promiss, there is no code like orderby=false, etc. to do so)...

fascinating is that the order in the main form stays while this chaos is only in the continous form...

 

[waldemar]

Well... for people with a similar problem:

A simple me.orderbyon=true in the continous form's current event did the trick. Amazing that in the regular single form this is not neccessary...