Sort Data on a Form and Subform

[bg1]

I have a form with a subform based on a query, how can I get the data to sort
on the main form, then another sort on the subform. I know this must be
basic, but I sure can't find it.

 

[KARL DEWEY]

If they both use the same query then sort both fields but make sure that the
high order sort is to the left of the other in design view before saving.
If they use separate queries then just sort each as needed.

 

[bg1]

Both use the same query and the main sort is in the left most column.

 

[John W. Vinson]

I have a form with a subform based on a query, how can I get the data to sort
on the main form, then another sort on the subform. I know this must be
basic, but I sure can't find it.

Both the Form and Subform have an "Order By" property; these can be set
independently. You'll need to set the OrderByOn property to Yes.

It's rather unusual to have both a form and subform using exactly the same
query; my guess is that doing so will interfere with updatability, but I'm not
sure!

 

[bg1]

I'm new at this. Where do you people learn all this stuff from?

 

[John W. Vinson]

I'm new at this. Where do you people learn all this stuff from?

Here, and the other newsgroups, for one thing; forty years experience with
computers, twenty with databases, and ten with Access for another. Just paying
back some tiny part of all the help I've gotten over the years!