Form Filtering

[Guest]

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.

 

[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.

 

[Guest]

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?

 

[Douglas J. Steele]

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

 

[Guest]

Each query filters for a different type of product.

 

[Douglas J. Steele]

Can you not create a parameter, and only have a single query?

 

[Guest]

I'm not sure. How would I do that?

Can you not create a parameter, and only have a single query?

 

[Douglas J. Steele]

What does your WHERE clause look like today?

Take a look at http://support.microsoft.com/kb/304352/

It's also possible to have parameters point to controls on a form, rather
than pop up and prompt the user.

 

[Douglas J. Steele]

You might also download the Database of Access 2000 sample queries at
http://office.microsoft.com/en-us/access/HA011201381033.aspx