sort ASC and DES

[a]

thank you

I have form and sub form I always do sort to the subform by using sortcut
menu (sort asending) the problem is :

The subform save (orderby) to the sort

Example

If I (sort ascending) by playername the orderby =Query1.playername (the is
the written beside the) orderby properties



Notes:

Subform is bond to query



What is my problem

I want order by not save the sort or order by = null value



Can I do that by command button in main form

Example

Command button remove the value of order by

Let order by = null value

Thank you