Displaying a subset of child records

[Dina]

I have an Access form based on an SQL Server database.

I have a customer table and an order table.

I have created a form that displays a customer with a subform for his
orders.
This works ok as long as I want to see ALL the orders for a specific
customer.

However, sometimes I wish to show only one specific order. I have no problem
getting the customer id but how do I limit the sub-form to show only the
order I require?

Many thanks
DM

 

[Kelvin]

Without knowing more about how you are defining which order to show, here is
one suggestion. I assume your record source for the subform is a query, so
just create another query with the criteria you want. Then based on your
situation change the record source for your subform to the appropriate
query.

Kelvin

 

[Dina]

thanx for the help... worked like a charm...

--

Dina Mann
Phone: 718-609-1700 Ext. 246
Fax: 718-371-3633
E-mail: (e-mail address removed)