Link between Combobox

[Agamemnon]

Hi,


I have the following problem: I've created a query that links two tabels "category" and "sub-category"
result is as follows:
Category Sub-Category

Diary Milk
Diary Yoghourt
Diary Others
Drinks Beer
Drinks Water
...

Now I have created a form that serves as input for a table "Products" with two Comboboxes from where I can easily choose in which category and sub-category a product can be placed.

Now I want to Impose some filter on those comboboxes:
For example if I choose the category "Diary" that the second combobox should only give me the possibilities Milk,Yoghourt and Others and NOT all the other sub-categories.


I hope my question is clear and that someone can help me out.

Very basic access user,
Agamemnon

 

[Mile-O]

Seach on this forum for cascading combo boxes as there have been multitudes of examples.