Displaying a subset of child records

  • Thread starter Thread starter Dina
  • Start date Start date
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
 
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
 
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)
 
Back
Top