Costum Sort order in Subform

[ootkhopdi]

Hi

i have a subform with year and month
subform shows result of a select query ,
when i open query seperatly it show data as requred order but when i show data in subform releted to this query , data show in rearrange order

how can i set order in subform as query reslut

 

[CJ_London]

sort it in your query in the order you require - it is possibly coincidence the order of the query happens to be the order you want.

 

[ootkhopdi]

data show in query but not in subform datasheet

 

[JHB]

Look if you anything in the "Order By" in the form's property data sheet?