Help with linking fields (1 Viewer)

[Prysson]

This is kinda difficult to explain...but here goes.

Lets say I have two forms.

One is a list of product categories....the other is a list of Products the tbls would be organized in this manner


tblProducts

ProductID Autonumber
ProductCategoryID Number
Product Text
ProductActive Yes/No


tblProductCategory

ProductCategoryID Autonumber
ProductCategory Text


Now obviously the tables are linked by ProductCategoryID

Lets say I want to create a form

In this form I want a Combo box and a list box....the combo box I want to be a list of Product Categories.

The List Box I want to be a list of products with their active/inactive status.

When I select a product category in the combo box I want the list box to automatically update itself to display the associated products.

How can I do this?

 

[Travis]

See Microsoft Knowledge Base articles:

ACC: How to Create Synchronized Combo Boxes
ID: Q98660

ACC: How to Synchronize Two Combo Boxes on a Form
ID: Q97624

 

[Prysson]

Thank that solved my question perfectly!