Displaying a subset of child records

D

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
 
K

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
 
Top