Form Filtering

A

awach

I have a subform whose record source contains the data for all the cutomers
and products I have. What I want is for the form to be sorted first by
customer then by product (having the products be ordered from highest priced
to lowest). Is there a way to do this using the "filter" and "order by"
control for the form? Thanks.
 
D

Douglas J. Steele

Ensure that your form and subform are properly linked via the
LinkChildFields and LinkMasterFields properties of the subform control on
the main form.


Create a query that sorts the data in the order you want, and use the query
rather than the table for your subform's recordset.
 
A

awach

I've tried creating queries but there are quite a few of them (14)...one
query for each type of product. I was hoping that there was another way to
do it to avoid the queries. Any ideas?
 
D

Douglas J. Steele

You'll have to provide more details. Why are there 14 different queries?
What's the difference between them?
 
Top