Newbie Question - linking tables with a query

[Suz]

I have a list of companies and I wanted to be able to
press a button on the form that takes the user to the
list of products for only that company. Right now I have
a button that takes the user to another form that just
has a long list of products. They have to scroll through
it to find the products associated with the specific
company. Any assistance is greatly appreciated.

 

[Denny G.]

I have the perfect example for your question. Go to the
Northwind Sample Database that is part of MS Access and
take a look at the "Suppliers" form. At the bottom of the
form is a button (Review Products) that displays all the
products for the the supplier displayed in the current
form. You can use this as a template for your form.

Denny G.

 

[John Vinson]

I have a list of companies and I wanted to be able to
press a button on the form that takes the user to the
list of products for only that company. Right now I have
a button that takes the user to another form that just
has a long list of products. They have to scroll through
it to find the products associated with the specific
company. Any assistance is greatly appreciated.

The simplest way to do this is to make the second Form a Subform of
the first one, linked by CompanyID.

 

[Suz]

Thank you - took a bit of finddling but it is working
perfectly now!!