How to sort query in subform

I have created a query with sorting order specified. However, when I using subform to link that query, the sorting function disappeared under subform environment!! Any idea?? Thanks!!

rickyfong said:

I have created a query with sorting order specified. However, when I using subform to link that query, the sorting function disappeared under subform environment!! Any idea?? Thanks!!

Click to expand...

Ricky,
Not sure what you mean by "using subform to link that query" but....
you can set the OrderBy property in the vba. be sure to set OrderByOn = true.

so... after you change or requery the data in the subform...
add
Forms![YourMainForm]![YourSubForm].form.OrderBy = "YourCol1, YourCol2, etc..."
Forms![YourMainForm]![YourSubForm].form.OrderByOn = True
hth,
..bob