Sort Data on a Form and Subform

  • Thread starter Thread starter bg1
  • Start date Start date
B

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.
 
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.
 
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.
Click to expand...

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!
 
I'm new at this. Where do you people learn all this stuff from?
Click to expand...

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!
 
Back
Top